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;