Join the SingleStore Community Today
Get expert advice, develop skills, and connect with others.
Drop the specified table.
DROP TABLE [IF EXISTS] tbl_name [FORCE]
tbl_nameis the name of a table in a SingleStore DB database.
DROP TABLEcommand waits for the running queries to finish before dropping the table. To override this behavior and kill any running queries, use the
DROP TABLEcommand is run. For information on when/how much table memory is freed when this command is run, see Memory Management.
memsql> DROP TABLE IF EXISTS mytbl;
memsql> DROP TABLE IF EXISTS tab1 FORCE;