Using SQL command to drop table

The drop table statement removes the specified table and all its associated indexes from the database.

By default, if the named table does not exist then this statement fails. You don't get an error if the optional IF EXISTS clause is specified and the table does not exist.

DROP TABLE demo_acct

Note:

To drop a MR Table, first drop all of its child tables. Otherwise, the DROP statement results in an error.