DROP TABLE

Drops a table. 

Syntax

DROP TABLE [schema_name.]table_name;

Description

Internally, the command only marks a table for deletion. The dropped table is physically deleted later by the background maintenance service. New queries will not see the dropped table, but in-flight queries will finish executing successfully, as if they finished execution right before the table was dropped.

See Also

CREATE TABLE

TRUNCATE TABLE