使用SQL Delete命令删除记录

SQL Delete命令用于删除SQL数据库中的记录，下面就为您详细介绍SQL Delete命令的用法，希望可以让您对SQL Delete命令有更深的认识。

DELETE 声明
The DELETE statement is used to delete rows in a table.
DELETE 声明常用来删除表中的数据。

语法
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” 的所有个人信息将被删除：

DELETE FROM Person WHERE LastName = ‘Rasmussen’

结果

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:
可以不删除数据表且删除里面的所有记录行。这就意味着数据表构架，属性以及索引都会完整保留：

DELETE FROM table_name或DELETE * FROM table_name
 

【编辑推荐】

sql server系统表说明

Sql Server全文索引的迁移

SQL Server全文索引的用法

SQL Server删除表信息的三种方法

SQL Server系统表的应用