Drop table

drop table — removes the table from the catalog and clears its data.

After drop, the table can no longer be selected from.

SQL

create table T;

insert into T ({x: 1});

drop table T;

select * from T;

Expected error: static

A table re-created after drop is fresh and empty.

SQL

create table T;

insert into T ({x: 1}, {x: 2});

drop table T;

create table T;

select * from T;

Result

[]

Dropping an undeclared table is a static error.

SQL

drop table Ghost;

Expected error: static