CREATE

The CREATE statement allows to create tables and indices.

General format

EXEC SQL [AT Database]     CREATE Options   END-EXEC

Syntax rules

1.	Options is passed to the driver without further checks. Refer to the database documentation for detailed syntax. Syntax errors, if any, are returned at runtime.

General Rules

1.	Database identifies the active connection that will execute the query and must be previously defined using a Format 4 DECLARE statement.

Examples

Create a table

exec sql    create table customers           (cust-code numeric(4) not null,             cust-name char(30)) end-exec