Progress
Basic Database
Tools


Generating CREATE VIEW Statements

Follow these steps to generate a CREATE VIEW statement for a view:

  1. Choose PRO/SQL Dump as CREATE VIEW Statement. Progress alphabetically lists all the views defined for your database.
  2. Select a view or type ALL.
  3. Specify the name of the output file. The default is the name of the view, with a .p extension.
  4. 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.
  5. After generating the file, Progress prompts you to continue.

  6. 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