Use drop table to remove a table from a database.
drop table [[database.]owner.] table_name [, [[database.]owner.] table_name]...
This command removes the specified tables from the database, together with their contents and all indexes and privileges associated with them. Rules or defaults bound to the table are no longer bound, but are otherwise not affected.
You must be the owner of a table in order to drop it. However, no one can drop a table while it is being read or written to by a user or a front-end program. 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 as long as 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.
