SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

SQL/MX Statements
HP NonStop SQL/MX Reference Manual—523725-004
2-86
Syntax Description of CREATE TABLE
ATTRIBUTE[S] attribute [,attribute]...
specifies attributes of the physical file that holds the table. In an ATTRIBUTES
clause that is within a PARTITION clause, you must separate attributes with a
space. In ATTRIBUTES clauses in other places, you can separate attributes
with either a space or a comma. You can specify these file attributes:
If you use the LIKE specification and you do not specify ATTRIBUTE[S]
attribute [,attribute]..., NonStop SQL/MX uses the attributes
associated with the source-table.
For more information, see the entry for a specific attribute.
LIKE source-table [include-option]...
directs NonStop SQL/MX to create a table like the existing table, source-table,
omitting constraints (with the exception of the NOT NULL and NOT DROPPABLE
PRIMARY KEY constraints), headings, and partitions unless include-option
clauses are specified. The source-table must be the ANSI name of an SQL/MX
format table (you cannot specify an SQL/MP table).
ATTRIBUTE[S] attribute [,attribute]... and the STORE BY
store-option are copied from the source-table if they are not explicitly
specified as file options following the LIKE specification.
The include-option clauses are specified as:
WITH CONSTRAINTS
directs NonStop SQL/MX to use constraints from source-table. Constraint
names for table are randomly generated unique names. NonStop SQL/MX
does not include FOREIGN KEY table constraints or REFERENCES column
constraints.
ALLOCATE/DEALLOCATE
on page 8-2
Controls amount of disk space allocated.
AUDITCOMPRESS on
page 8-3
Controls whether unchanged columns are included
in audit records.
BLOCKSIZE on page 8-4 Sets size of data blocks. 4096 is the only supported
value.
CLEARONPURGE on
page 8-5
Controls disk erasure when table is dropped.
EXTENT on page 8-6 Controls size of extents that are allocated on disk.
MAXEXTENTS on
page 8-8
Controls maximum disk space to be allocated.