DROP a table
From SQLZoo
DROP an unwanted table
schema:scott
Naturally, all of the data in the table is lost when the table is dropped.
Foreign Key references can cause problems.
CREATE TABLE t_test
(a INTEGER NOT NULL PRIMARY KEY
,b VARCHAR(10)
)
DROP TABLE t_test