DROP TABLE
Drop the specified table.
Syntax
DROP [TEMPORARY] TABLE [IF EXISTS] <table_name> [FORCE];
Remarks
<table_name>
is the name of a table in a SingleStore database.This command can be run on the master aggregator node, or a child aggregator node (see Node Requirements for SingleStoreDB Commands ).
This command causes implicit commits. See COMMIT for more information.
If there is a view which depends on a table, the table cannot be dropped. See CREATE VIEW for more information.
By default, the
DROP TABLE
command waits for the running queries to finish before dropping the table. To override this behavior and kill any running queries, use theFORCE
option.Table memory can be freed when the
DROP TABLE
command is run.For information on when/how much table memory is freed when this command is run, see Managing Memory.
DROP TEMPORARY TABLE
does not perform aCOMMIT
when run; issue aCOMMIT
prior toDROP TEMPORARY TABLE
if there are uncommited statements.Because temporary tables only exist for the duration of a client session, no access privileges are required to run
DROP TEMPORARY TABLE
.Unlike when running the
DROP TABLE
command, running theDROP TEMPORARY TABLE
command does not commit implicitly.DROP TEMPORARY TABLE
cannot drop global temporary tables.A temporary or global temporary table can be dropped using
DROP TABLE
without specifying theTEMPORARY
option.See the Permission Matrix for the required permission.
Example
DROP TABLE IF EXISTS mytbl;
DROP TABLE IF EXISTS tab1 FORCE;