-
From the tree view, expand the server containing the database you want to modify.
-
Expand the database that contains the view you want to modify.
-
Click the Views node.
-
Select the view you want to modify.
The view definition appears in the properties view.
-
Make the necessary changes to the view definition, and click Store.
The view is updated and assumes one of the following view states:
-
Unapplied View
-
Unapplied Modification to an Applied View
-
Unapplied Delete to an Applied View
The preceding view states mean that the change is not yet incorporated into the SQL catalog.
-
-
Follow the steps outlined in Applying Schema Modifications earlier in this section to incorporate this change into the SQL catalog.
After the change is incorporated into the SQL catalog, the view state is displayed as Applied View.
