Restrictions for drop table

You cannot use the drop table command on system tables.

You can drop a table in any database, as long as you are the table owner. For example, use either of the following to drop a table called newtable in the database otherdb:

drop table otherdb..newtable

drop table otherdb.yourname.newtable

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