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
sql
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
:
sql
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.
Danger
DROP TABLE
cannot be undone. Use it with care!
Syntax
sql
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:
sql
DROP TABLE monitor;
DROP TABLE monitor;
DROP FLOW
sql
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.
sql
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
sql
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.
sql
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)