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;