Topic group Related topics

Creates and opens a table that you can use to design the structure of a new table.

Syntax

CREATE <filename> STRUCTURE EXTENDED
[[TYPE] PARADOX | DBASE]

<tablename> | ?

The name of the table you want to create.

[TYPE] PARADOX | DBASE

Specifies the type of table you want to create, if <filename> does not include an extension. This option overrides the current SET DBTYPE setting. The TYPE keyword is included for readability only; it has no effect on the operation of the command.

Description

CREATE...STRUCTURE EXTENDED creates an empty table, called a structure-extended table, containing five fields of fixed names, types, and lengths. The fields correspond to attributes that describe fields in the table you want to create:

Field

Contents

FIELD_NAME

Character field that contains the name of the field.

FIELD_TYPE

Character field that contains the field's data type.

FIELD_LEN

Numeric field that contains the field length.

FIELD_DEC

Numeric field that contains the number of decimal places for numeric fields.

FIELD_IDX

Character field that indicates if index tags were created on individual fields in the table.

The CREATE...STRUCTURE EXTENDED command is similar to the COPY STRUCTURE EXTENDED command. However, unlike COPY STRUCTURE EXTENDED, which creates a table with records providing information on fields in the current table, CREATE...STRUCTURE EXTENDED creates an empty structure-extended table. After using CREATE...STRUCTURE EXTENDED to create a new table, add records to define the structure of a new table. Then use the CREATE...FROM command to create a new table from the field definitions stored in the structure-extended table.

OODML

Use the SQL command CREATE TABLE to create the STRUCTURE EXTENDED table.