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