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.