Materialize Logo

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

DROP TABLE IF EXISTS table_name
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;