Deleting Data in a Table

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

Concepts

Other Resources