DROP ​

DROP DATABASE ​

DROP DATABASE drops a database. It removes the catalog entries for the database and deletes the directory containing the data.

Syntax ​

DROP DATABASE [ IF EXISTS ] db_name

DROP DATABASE [ IF EXISTS ] db_name

• IF EXISTS: Do not throw an error if the database does not exist.
• db_name: The name of the database to remove.

Examples ​

To drop a database named test:

DROP DATABASE test;

DROP DATABASE test;

DROP TABLE ​

DROP TABLE removes tables from the database. It will remove the table definition and all table data, indexes, rules, and constraints for that table.

Syntax ​

DROP TABLE [ IF EXISTS ] table_name

DROP TABLE [ IF EXISTS ] table_name

• IF EXISTS: Do not throw an error if the table does not exist.
• table_name: The name of the table to remove.

Examples ​

Drop the table monitor in the current database:

DROP TABLE monitor;

DROP TABLE monitor;