Deleting Data in a Table

The topics in this section describe how you can delete data in an existing table in SQL Server.

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.

Community Additions