Deleting Data

Accessing and Changing Relational Data

previous page next page
Accessing and Changing Relational Data

Deleting Data

Microsoft® SQL Server™ supports these ways to delete data in an existing table:

  • The DELETE statement

  • The deletion of the current row in a result set or cursor

  • The TRUNCATE TABLE statement

The data modification statements work on views as well as on tables, with some restrictions. For more information, see Creating a View.

previous page start next page