Pressing this button will display all public and private views.
To easily maintain an existing view, display the views, select and copy the view of interest, paste the copied view text into the "Maintain View" text box, and then make the appropriate modifications.
Maintain Views
Any view created or replaced is private and visible only to your User Id.
Only private views can be dropped.
The View SQL is ANSI standard with any Postgres extensions you might require. The view text must start with either "Create or Replace View" or "Drop View".
Selecting Schema Description will open the ERD in a separate window. Opening multiple table description windows from the ERD, cutting\pasting column and table names is helpful in generating the views.
