Progress
Basic Database
Tools


Generating CREATE TABLE Statements

Follow these steps to generate a CREATE TABLE statement for a table:

  1. Choose PRO/SQL Dump as CREATE TABLE Statement. Progress alphabetically lists all the tables defined for your database.
  2. Select a table or type ALL.
  3. Specify the output filenames for the CREATE TABLE and CREATE INDEX statements. If you do not specify a filename for the CREATE INDEX statement, Progress writes the CREATE INDEX statement to the CREATE TABLE statement output file.
  4. Select the type of SQL-89 you want to use, 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