Removing a table or table-valued object does not delete anything from the database; it only removes it from the current query. For details about removing a table from a database, see How to: Delete ...
Deleting all rows from a table clears the data in the table but does not delete the table itself. To delete a table from a database, right-click the table in Object Explorer and click Delete. When you ...