Release 10.1A: OpenEdge Data Management:
SQL Reference

> ## CREATE TABLE

> Syntax
>     create table statement ::=
>     CREATE TABLE [ owner_name.]table_name
>       ( { column_definition | table_constraint }, ... )
>         [ AREA area_name ]
>     ;

>     create table statement ::=
>     CREATE TABLE [ owner_name.]table_name
>       [ (column_name [ NULL | NOT NULL] , ...) ]
>       [ AREA area_name ]
>       AS query_expression
>     ;

> ##### Column Definition

> Syntax
>     column_definition ::=
>     column_name data_type
>       [ DEFAULT { literal | NULL | SYSDATE } ]
>       [ column_constraint [ column_constraint ... ] ]

> ##### Column Constraint

> Syntax
>     column_constraint ::=
>     [ CONSTRAINT constraint_name ]
>        NOT NULL [ PRIMARY KEY | UNIQUE ]
>       | REFERENCES [ owner_name.]table_name [ ( column_name ) ]
>       | CHECK ( search_condition )

> ##### Table Constraint

> Syntax
>     table_constraint ::=
>     [ CONSTRAINT constraint_name ]
>         PRIMARY KEY ( column [, ... ] )
>       | UNIQUE ( column [, ...... ] )
>       | FOREIGN KEY ( column [, ... ] )
>         REFERENCES [ owner_name.]table_name [ ( column [, ... ] ) ]
>       | CHECK ( search_condition )

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