Choose this option to see the information about all SQL views defined for the working database.

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.

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.