SQL Delete命令用于刪除SQL數(shù)據(jù)庫(kù)中的記錄，下面就為您詳細(xì)介紹SQL Delete命令的用法，希望可以讓您對(duì)SQL Delete命令有更深的認(rèn)識(shí)。

DELETE 聲明
The DELETE statement is used to delete rows in a table.
DELETE 聲明常用來刪除表中的數(shù)據(jù)。

語法
DELETE FROM table_nameWHERE column_name = some_value

--------------------------------------------------------------------------------

Person:

LastName FirstName Address City
Nilsen Fred Kirkegt 56 Stavanger
Rasmussen Nina Stien 12 Stavanger

--------------------------------------------------------------------------------

Delete a Row
刪除一條記錄
"Nina Rasmussen" is going to be deleted:
"Nina Rasmussen" 的所有個(gè)人信息將被刪除：

DELETE FROM Person WHERE LastName = 'Rasmussen'

結(jié)果

LastName FirstName Address City
Nilsen Fred Kirkegt 56 Stavanger

--------------------------------------------------------------------------------

Delete All Rows

刪除所有記錄
It is possible to delete all rows in a table without deleting the table. This means that the table structure, attributes, and indexes will be intact:
可以不刪除數(shù)據(jù)表且刪除里面的所有記錄行。這就意味著數(shù)據(jù)表構(gòu)架，屬性以及索引都會(huì)完整保留：

DELETE FROM table_name或DELETE * FROM table_name
 

【編輯推薦】

sql server系統(tǒng)表說明

Sql Server全文索引的遷移

SQL Server全文索引的用法

SQL Server刪除表信息的三種方法

SQL Server系統(tǒng)表的應(yīng)用