Deleting Data in a Table

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

In This Section

Topic Description

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

Concepts

Updating Data in a Table

Other Resources

Inserting Data into a Table
DELETE (Transact-SQL)
TRUNCATE TABLE (Transact-SQL)
TOP (Transact-SQL)

Help and Information

Getting SQL Server 2005 Assistance