DROP TABLE

DROP TABLE removes a table from Materialize.

Syntax

mzsql

DROP TABLE [IF EXISTS] <table_name> [RESTRICT|CASCADE];

Syntax element	Description
IF EXISTS	Optional. If specified, do not return an error if the named table doesn't exist.
`<table_name>`	The name of the table to remove.
CASCADE	Optional. If specified, remove the table and its dependent objects.
RESTRICT	Optional. Don't remove the table if any non-index objects depend on it. (Default.)

Create a table t and verify that it was created:

mzsql

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

TABLES
------
t

Remove the table:

mzsql

DROP TABLE t;

Create a table t:

mzsql

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:

mzsql

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:

mzsql

DROP TABLE t CASCADE;

You can use either of the following commands:

mzsql

DROP TABLE IF EXISTS t;

The privileges required to execute this statement are:

{{% include-headless "/headless/sql-command-privileges/drop-table" %}}