Restrictions for drop table

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.