Progress
Basic Database
Tools
Generating CREATE VIEW Statements
Follow these steps to generate a CREATE VIEW statement for a view:
- Choose PRO/SQL
Dump as CREATE VIEW Statement. Progress alphabetically lists all the views defined for your database.
- Select a view or type ALL.
- Specify the name of the output file. The default is the name of the view, with a .p extension.
- Specify whether Progress should use a period (.) or a semi-colon (;) as the symbol for the termination of the CREATE VIEW statement, then choose OK.
After generating the file, Progress prompts you to continue.
- Choose OK to return to the Data Dictionary main window.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |