Progress
Basic Database
Tools
Generating CREATE TABLE Statements
Follow these steps to generate a CREATE TABLE statement for a table:
- Choose PRO/SQL
Dump as CREATE TABLE Statement. Progress alphabetically lists all the tables defined for your database.
- Select a table or type ALL.
- 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.
- Select the type of SQL-89 you want to use, 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 |