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 Reports option 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. The Dump CREATE VIEW of All Views dialog box shown in the following figure appears.
Figure 71. Dump CREATE VIEW of All Views dialog box
The Dump CREATE VIEW of All Views 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.
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.