Drop Tables

Use drop table to remove specified tables from the database, together with their contents and all indexes and privileges associated with them. Rules or defaults that are bound to the table are no longer bound, but are otherwise not affected.

You must be the owner of a table to drop it. However, no one can drop a table while it is being read or written to by a user or application. You cannot use drop table on any system tables, either in the master database or in a user database.

You can drop a table in another database if you are the table owner.

If you delete all the rows in a table or use truncate table on it, the table exists until you drop it.

drop table and truncate table permission cannot be transferred to other users.