The SQL DROP statement permanently removes database objects such as tables, views, or indexes.
To drop a database, use the following syntax:
DROP DATABASE dbname;
To drop a table, use the following syntax:
DROP TABLE tablename;
You can also use the TRUNCATE TABLE statement to delete all rows from a table, but not the table itself:
TRUNCATE TABLE tablename;