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/消除乾淨 整個表(的定義),也會刪除掉所有的行(信息)。

參考:


Drop a Table

posted @ 2016-09-20 17:07  xiulug  阅读(166)  评论(0编辑  收藏  举报