Release 10.1A: OpenEdge Development:
Basic Database Tools

> ## Dump as CREATE TABLE Statements option

> 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-OpenEdge databases.

> When you choose this option, the Data Dictionary 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–15 appears.

> Figure 11–15: Dump CREATE TABLE dialog box

> The Dump CREATE TABLE dialog box contains the following fields:

> - 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, the Data Dictionary writes the CREATE INDEX statements to the CREATE TABLE output file.

> - SQL-Flavor

> Specifies the type of SQL you want to use.

> - Create Progress Recid Field

> Select this option if your database currently contains the `PROGRESS_RECID` field. Selecting this option will maintain the use of `PROGRESS_RECID` in any new tables added by this utility.

> - Create Shadow Columns

> If your Dataserver is configured with a case sensitive code page, this box is available for selection. Selecting it provides case insensitivity compatible with the behavior of an OpenEdge database.

> - Include Defaults

> Check if you want the OpenEdge initial value used as the default in the SQL script.

> - For Field Widths Use Width

> Select if your OpenEdge database contains data that is larger than the display format. Change the width to the proper size. The utility will use the Width field instead of the display format.

> - For Field Widths Use 4GL Format

> Select if you want the Data Dictionary to use the display format instead of the field’s width.

> - Expand x(8) to 30

> If selected, indicates that fields with `FORMAT` set to x(8) will be given a default width of 30 characters.

> After generating the file, the Data Dictionary prompts you to continue.

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