Progress
Basic Database
Tools


PRO/SQL>Dump as CREATE TABLE Statements

Choose PRO/SQL Dump as CREATE TABLE and CREATE INDEX statements to generate an SQL DDL program that contains CREATE TABLE statements equivalent to those originally used to define the selected table.

NOTE: This option also works with non-Progress databases.

When you choose this option, Progress alphabetically lists all the tables defined for your database. Select the table for which you want to make CREATE TABLE statements. A dialog box similar to the one shown in Figure 11–16 appears.

Figure 11–16: Dump CREATE TABLE Dialog Box

This dialog box contains the following user-interface elements:

Output File for CREATE TABLE

Specifies the filename to which you want to write the CREATE TABLE statements. The default filename for a single table is the table-name.p or database-name.p if you specified all tables.

Output File for CREATE INDEX

Specifies the filename to which you want to write the CREATE INDEX statements. The default filename for a single table is the table-name.i or database-name.i if you specified all tables. If you do not specify a filename, Progress writes the CREATE INDEX statements to the CREATE TABLE output file.

SQL-Flavor

Specifies the type of SQL you want to use.

After generating the file, Progress prompts you to continue.


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095