DROP TABLE
DROP TABLE removes a table from your Materialize instance.
Conceptual framework
Tables store non-streaming data that is inserted via INSERT
statements. DROP TABLE removes tables from your Materialize instance.
Syntax
| Field | Use |
|---|---|
| IF EXISTS | Do not return an error if the named table does not exist. |
| table_name | The name of the table to drop. |
Examples
Dropping a table
We can create a table t and verify that it was created with the following
statements:
CREATE TABLE t (a int, b text NOT NULL);
SHOW TABLES;
TABLES
------
t
We can then remove the table from the Materialize instance with a DROP statement.
DROP TABLE t;