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 “DatabaseReports” 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 |