The DROP TABLE
statement is used to drop an existing table in a database.
DROP TABLE
table_name;
Note: Be careful before dropping a table. Deleting a table will result in loss of complete information stored in the table!
The following SQL statement drops the existing table "Shippers":
DROP TABLE Shippers;
The TRUNCATE TABLE
statement is used to delete the data inside a table, but not the table itself.
TRUNCATE TABLE
table_name;
截取页面反馈部分,让我们更快修复内容!也可以直接跳过填写反馈内容!