Microsoft® SQL Server™ supports these ways to delete data in an existing table:
The data modification statements work on views as well as on tables, with some restrictions. For more information, see Creating a View.