Try OpenEdge Now
skip to main content
Basic Database Tools
Advanced Menus Reference : PRO/SQL menu options : PRO/SQL View Report option
 

PRO/SQL View Report option

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 Database Menu 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.