SQL 刪除
SQL 刪除
1、delete from table_name
2、drop table table_name
drop table
is different from deleting all of the records
in the table. Deleting all of the records in the table leaves the table including column and constraint information. Dropping the table removes the table definition as well as all of its rows.
drop table
不同於 delete from *table_name*
。delete/刪除 一個 table 中的所有 recodrd/記錄,會留下所有的 column和constraint 信息。drop table
會 remove/消除乾淨 整個表(的定義),也會刪除掉所有的行(信息)。
參考: