View to Edit Mode *with a Wizard at the end*

1. Where do you see the Edit mode?
2. What is the use of edit mode?
3. How do I edit a view in SQL Server Management Studio?

Where do you see the Edit mode?

The edit mode you are currently using is shown on the status bar at the bottom of the module window.

What is the use of edit mode?

Edit mode reduces errors that occur when two users edit a record in the same application at the same time. Edit mode does not eliminate all error occurrences when two users are editing a record. For example, errors can still occur when two users edit the same record in two different applications.

How do I edit a view in SQL Server Management Studio?

Using SQL Server Management Studio

Right-click on the view you wish to modify and select Design. In the diagram pane of the query designer, make changes to the view in one or more of the following ways: Select or clear the check boxes of any elements you wish to add or remove.