DROP-TABLE
DROP-TABLE
Name
DROP TABLE
Description
This statement is used to drop a table. grammar:
DROP TABLE [IF EXISTS] [db_name.]table_name [FORCE];
illustrate:
- After executing
DROP TABLE
for a period of time, the dropped table can be recovered through the RECOVER statement. See RECOVER statement for details - If you execute
DROP TABLE FORCE
, the system will not check whether there are unfinished transactions in the table, the table will be deleted directly and cannot be recovered, this operation is generally not recommended
Example
Delete a table
DROP TABLE my_table;
If it exists, delete the table of the specified database
DROP TABLE IF EXISTS example_db.my_table;
Keywords
DROP, TABLE