Spec-Zone .ru
спецификации, руководства, описания, API
|
To create a new view, right-click the Views node under the connection node in Server Explorer. From the node's context menu, choose the
command. This command opens the SQL Editor.You can then enter the SQL for your view.
To modify an existing view, double-click a node of the view to modify, or right-click this node and choose the
command 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:
Catalog
Check Option
Definer
Definition
Definer
Is Updatable
Name
Schema
Security Type
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.
The properties Is Updatable
and Schema
are readonly.
To save changes you have made, use either Control+S.
or buttons of the Visual Studio main toolbar, or press