Delete Table/Database

The DROP statement is used to delete table or the entire database.

Delete Table:

DROP TABLE table_name;

Delete Database:

DROP DATABASE database_name;

The DROP TABLE statement deletes the specified table along with the entire data that it contains. Similarly, the DROP DATABASE statement deletes the entire database along with all the data contained in it.

Note : An error condition may occur for a DROP TABLE statement if there are existing constraints such as foreign keys that are dependent on the table.