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.