Skip to main content
Version: 0.8

DROP

DROP DATABASE​

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

Danger

DROP DATABASE cannot be undone. Use it with care!

Syntax​

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 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.

Danger

DROP TABLE cannot be undone. Use it with care!

Syntax​

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;