DROP TABLE
DROP TABLE removes a table from the catalog immediately. With vacuum: true,
a running server deletes its stored files on the next hourly
vacuum sweep after retention
expires (four hours by default). The standalone shell does not run vacuum.
Example
Section titled “Example”DROP TABLE IF EXISTS staging_events;Syntax
Section titled “Syntax”DROP TABLE [IF EXISTS] [[datastore.]schema.]table;Parameters
Section titled “Parameters”Qualify the table name with a schema and, optionally, a datastore. An unqualified name uses the default datastore and schema.
IF EXISTS permits the statement to succeed when the table is absent.
Additional example
Section titled “Additional example”For a table in the analytics schema:
DROP TABLE analytics.events;Limitations
Section titled “Limitations”CASCADE is not supported.
Parquet files adopted from outside the table’s storage directory with
with_pre_existing_parquets
are not deleted.