Progress
Basic Database
Tools
PRO/SQL>PRO/SQL View Report
Choose this option to see the information about all SQL views defined for the working database.
NOTE: Views of non-Progress 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, Progress alphabetically lists all the views defined for your Progress database. Select the views for which you want information. Figure 11–14 shows the first portion of an example view report.
Figure 11–14: View Report
![]()
The View Report 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. Progress prompts you for the printer or filename, whether you want to append the report to an existing file, and the page length.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |