You can open views for performing tasks, such as adding tables, changing join conditions, or other modifications you want to make to a view.
To open a view for editing
-
Perform one of the following:
-
Open the application project containing the view in the Project Manager. Click the view, and then Modify.
-OR-
-
Open the database containing the view in the Database Designer. Click the view, and on the Database menu, click Modify.
The View Designer opens to display the view.
-
Open the application project containing the view in the Project Manager. Click the view, and then Modify.
For more information, see How to: Open Databases and How to: Edit Files in Projects.
To open a view programmatically
-
Open a database containing the view.
-
Use the MODIFY VIEW command with the name of the view.
For more information, see MODIFY VIEW Command.