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.

See Also

Reference

DELETE (Transact-SQL)

TRUNCATE TABLE (Transact-SQL)

TOP (Transact-SQL)

Concepts

Updating Data in a Table

Other Resources

Inserting Data into a Table