Deleting Data in a Table
The topics in this section describe how you can delete data in an existing table in SQL Server.
In This Section
Deleting Rows by Using DELETE
Describes how to delete rows using the DELETE statements.
Deleting Rows in Result Sets
Describes how to delete the current row in a result set or cursor.
Deleting All Rows by Using TRUNCATE TABLE
Describes how to delete all rows in a table using the TRUNCATE TABLE statement.
Limiting Deleted Rows by Using TOP
Describes how to use the TOP clause to limit the number of rows that are deleted in a DELETE statement.