Skip to main content
Version: 0.9

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;

DROP FLOW

DROP FLOW [ IF EXISTS ] flow_name;
  • IF EXISTS: Do not throw an error if the flow does not exist.
  • flow_name: The name of the flow to destroy.
DROP FLOW IF EXISTS test_flow;
Query OK, 0 rows affected (0.00 sec)

DROP VIEW

DROP VIEW [ IF EXISTS ] view_name;
  • IF EXISTS: Do not throw an error if the view does not exist.
  • view_name: The name of the view to remove.
DROP VIEW IF EXISTS test_view;
Query OK, 0 rows affected (0.00 sec)