You can execute the DROP TABLE
statement to delete a table.
Syntax
DROP TABLE db_name.table_name;
Note When you execute this statement, both the table data and schema are deleted.
Example
DROP TABLE adb_demo.customer;