Progress
Basic Database
Tools


PRO/SQL>Dump as CREATE VIEW Statement

Choose PRO/SQL Dump as CREATE VIEW Statement to generate an SQL DDL program that contains CREATE VIEW statements equivalent to those originally used to define the selected view.

NOTE: Views of non-Progress databases are treated as tables. To display information for these views, use the table reports option. See the “Database Reports” section earlier in this manual for more information on generating a table report.

When you choose this option, Progress alphabetically lists all the views defined for your Progress database. Select the views for which you want make CREATE VIEW statements. A dialog box similar to the one shown in Figure 11–15 appears.

Figure 11–15: Dump CREATE VIEW Dialog Box

This dialog box contains the following user-interface elements:

Output File

Specifies the filename to which you want to write the CREATE VIEW statements. The default filename is either the view or database name with a .p extension.

Statement Termination

Specifies the statement termination character. The options are a period (.) or a semi-colon (;). The default value is a period (.).

Which User

If all views are selected, specifies all users or the User ID of the single user for whom you want to dump the views. The default value is All Users.

After generating the file, Progress prompts you to continue.


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095