Choose this option to see the information about all SQL views defined for the working database.
Note: Views of non-OpenEdge databases are treated as tables. To display information for these views, use the table reports option. See DatabaseMenu Reference for more information on generating a table report.
When you choose PRO/SQL > PRO/SQL View Report, the Data Dictionary alphabetically lists all the views defined for your database. Select the views for which you want information. The following figure shows the first portion of a View Report window.
Figure 70. View Report dialog box
The View Report window contains the following fields:
View Name —The name of the view
Updatable — Whether the view is updatable
Group By — Whether the view is defined with a GROUP BY clause
Check Option — Whether the view is defined with a CHECK OPTION WHERE clause
View Name — View name of the currently displayed view
Base Tables — Tables from which the view gets its information
Where Clause — The WHERE clause
View Def — The SQL statement executed when defining the view
Can-Read — Users who can read the rows of the view
Can-Write — Users who can update records of the view
Can-Create — Users who can create new records
Can-Delete — Users who can delete records from the view
Order — Order of the columns within the view
View Column Name — Names of the columns that comprise the view
Base Columns — Base table field names for each view column
To send the report to a file or printer, choose Print. The Data Dictionary prompts you for the printer or filename, whether you want to append the report to an existing file, and the page length.
View Name —The name of the view