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