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.

Field	Use
IF EXISTS	Do not return an error if the named table doesn’t exist.
table_name	The name of the table to remove.
CASCADE	Remove the table and its dependent objects.
RESTRICT	Don’t remove the table if any non-index objects depend on it. (Default.)

Create a table t and verify that it was created:

CREATE TABLE t (a int, b text NOT NULL);
SHOW TABLES;

TABLES
------
t

Remove the table:

DROP TABLE t;

Create a table t:

CREATE TABLE t (a int, b text NOT NULL);
INSERT INTO t VALUES (1, 'yes'), (2, 'no'), (3, 'maybe');
SELECT * FROM t;

a |   b
---+-------
2 | no
1 | yes
3 | maybe
(3 rows)

Create a materialized view from t:

CREATE MATERIALIZED VIEW t_view AS SELECT sum(a) AS sum FROM t;
SHOW MATERIALIZED VIEWS;

name    | cluster
--------+---------
t_view  | default
(1 row)

Remove table t:

DROP TABLE t CASCADE;

You can use either of the following commands:

DROP TABLE IF EXISTS t;