Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
The topics in this section describe how you can delete data in an existing table in SQL Server 2005.
In This Section
| Topic | Description |
|---|---|
Describes how to delete rows using the DELETE statements. |
|
Describes how to delete the current row in a result set or cursor. |
|
Describes how to delete all rows in a table using the TRUNCATE TABLE statement. |
|
Describes how to use the TOP clause to limit the number of rows that are deleted in a DELETE statement. |
See Also
Concepts
Other Resources
Inserting Data into a Table
DELETE (Transact-SQL)
TRUNCATE TABLE (Transact-SQL)
TOP (Transact-SQL)