To create a new view, right-click the Views node under the connection node in Server Explorer. From the node's context menu, choose thecommand. This command opens the SQL Editor.
You can then enter the SQL for your view, and then execute the statement.
To modify an existing view, double-click a node of the view to modify, or right-click this node and choose thecommand from a context menu. Either of the commands opens the SQL Editor.
All other view properties can be set in the Properties window. These properties are:
Check Option: Whether or not the
WITH CHECK OPTIONclause is present. For additional information, see The View WITH CHECK OPTION Clause.
Definer: Creator of the object.
Definition: Definition of the view.
Is Updatable: Whether or not the view is
Updatable. For additional information, see Updatable and Insertable Views.
Name: The name of the view.
Schema: The schema which owns the view.
Security Type: The
SQL SECURITYvalue. For additional information, see Access Control for Stored Programs and Views.
Some of these properties can have arbitrary text values, others accept values from a predefined set. In the latter case, set the desired value with an embedded combobox.
Is Updatable and
Schema are read-only.
To save changes you have made, use either Control + S.or buttons of the Visual Studio main toolbar, or press