How to: Edit Views
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.
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.