Use SQL Server Management Studio

1. In Object Explorer, expand the database that contains the view you want to delete, and then expand the Views folder.
2. Right-click the view you want to delete and select Delete.
3. In the Delete Object dialog box, select OK. Important.

Expand the database that contains the view you wish to remove in Object Explorer, then expand the Views folder. Click the Delete option from the context menu when you wish to remove a view. Choose OK from the Delete Object dialogue box.

you can insert, update and delete a record in a view but there are some restrictions. Use the following procedure to create a sample to understand how to perform such tasks. Step 1: Create a schema of a table named “Employee” in your Database.

The DROP COLUMN command is used to delete a column in an existing table.

• Use SQL Server Management Studio:

1. In Object Explorer, expand the database that contains the view you want to delete, and then expand the Views folder.
2. Right-click the view you want to delete and select Delete.
3. In the Delete Object dialog box, select OK. Important.

Expand the database that contains the view you wish to delete in Object Explorer, then expand the Views folder. Select Delete from the context menu of the view you want to delete. Select OK in the Delete Object dialogue box.