Release 10.1A: OpenEdge Development:
Basic Database Tools

> ## Dump as CREATE VIEW Statement option

> 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-OpenEdge databases are treated as tables. To display information for these views, use the table reports option. See the "Reports option" section for more information on generating a table report.

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

> Figure 11–14: Dump CREATE VIEW dialog box

> The Dump CREATE VIEW dialog box contains the following fields:

> - 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, the Data Dictionary prompts you to continue.

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