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;

DROP FLOW ​

DROP FLOW [ IF EXISTS ] flow_name;

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;

DROP FLOW IF EXISTS test_flow;

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

DROP VIEW ​

DROP VIEW [ IF EXISTS ] view_name;

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;

DROP VIEW IF EXISTS test_view;

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)