Defining a Table Using c-treeACE SQL

The following c-treeACE SQL commands define a table consisting of three fields and an index defined on one of the fields:

CREATE TABLE example (

    dbl   float,

    int4  INTEGER,

    ch    CHAR(8));

CREATE INDEX example_chidx ON example (ch);

COMMIT WORK;