NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
C-148
CREATE TABLE Statement
CLUSTERING KEY clause for a key-sequenced table, SQL adds a SYSKEY
column to the table to use as the primary key.
References to keys in other tables, or any references that require a unique key,
should always use a primary key rather than a SYSKEY or clustering key.
Columns in the clustering key definition cannot be updated and cannot contain null
values, even if you omit the NOT NULL clause in the column definition.
See Primary Keys
on page P-27, Syskeys on page S-90, or Clustering Keys on
page C-26 for more information.
[ { ORGANIZATION } { K[EY SEQUENCED] } ]
[ { ORGANISATION } { E[NTRY SEQUENCED] } ]
[ { R[ELATIVE] } ]
specifies the file organization for the physical file that holds the table. See File
Organizations on page F-8 for more information. The default is KEY
SEQUENCED.
PARTITION ( partition [ , partition ] ... )
defines the secondary partitions of a partitioned table.
partition is the definition of a single secondary partition and includes the
location of the partition, the first key value for the partition, and (optionally) the
catalog, physical volume, and EXTENT and MAXEXTENTS values for the
partition. See PARTITION Clause
on page P-16 for details.
PARTITION ARRAY { STANDARD | EXTENDED }
specifies the type of partition array created for the underlying table and all
associated indexes:
The size of the partition array affects how many partitions can be created for a table
and its indexes. It also affects how many indexes can be created against the base
table. An extended partition array supports a larger number of indexes and table and
index partitions.
PARTITION ARRAY applies to partitions created later for a table, even if the table
is not initially partitioned. To change the setting for a table, use the ALTER TABLE
command.
You can use the PARTITION ARRAY clause in SQLCI or in dynamic SQL
statements. To check the value of PARTITION ARRAY, use the FILEINFO
DETAIL command.
Tables and indexes using extended arrays require a version 320 or later catalog.
DML and DDL statements on tables and indexes with extended arrays can be
EXTENDED specifies the extended partition array available for versions 320 and
later of NonStop SQL/MP
STANDARD specifies the type of array used by default by NonStop SQL/MP