1. Check if the copy table exists, if exists, drop it
2.
http://technet.microsoft.com/en-us/magazine/dd401720.aspx[
^]
User Insert into query to copy the contents of one table into another.
3. For dropping a table , you can write same c# code that you use for delete operation and replace the query appropriately.
4. for finding if a table exists you can use SP_HELP table_name
Submit an article or tip