NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
C-145
CREATE TABLE Statement
table
is a Guardian name (or an equivalent DEFINE) for the new table. The fully
expanded table name must be unique in the network. If the table is partitioned,
table identifies the primary partition.
The volume on which the table is created must be audited by the TMF subsystem,
even if the table itself is nonaudited.
If ServerWare SMF is installed on your node, the volume portion of table can be
either a virtual or direct volume. If you specify only a subvolume for table, SQL
places the table or primary table partition on the current default volume. If the
default is a virtual volume, the table or primary partition resides on the virtual
volume. If the default is a direct volume, the table or primary table partition resides
on the physical volume as a direct file not managed by ServerWare SMF.
LIKE source-table
directs SQL to create a table like the existing table or partition source-table,
omitting comments, constraints, headings, and help text unless the following clauses
are specified:
If you specify LIKE, you cannot specify ORGANIZATION or CLUSTERING KEY
because they are defined by source-table.
attribute-spec is:
{| ALLOCATE integer |}
{| { AUDIT | NO AUDIT } |}
{| { AUDITCOMPRESS | NO AUDITCOMPRESS } |}
{| BLOCKSIZE integer |}
{| { BUFFERED | NO BUFFERED } |}
{| { CLEARONPURGE | NO CLEARONPURGE } |}
{| { DCOMPRESS { 1 | 2 } | NO DCOMPRESS } |}
{| EXTENT { ( pri-ext-size[,sec-ext-size] ) } |}
{| { ext-size } |}
{| { ICOMPRESS | NO ICOMPRESS } |}
{| LOCKLENGTH integer |}
{| MAXEXTENTS integer |}
{| NOPURGEUNTIL date |}
{| RECLENGTH integer |}
{| { SERIALWRITES | NO SERIALWRITES } |}
{| TABLECODE integer |}
{| { VERIFIEDWRITES | NO VERIFIEDWRITES } |}
WITH COMMENTS uses comments from source-table
WITH CONSTRAINTS uses constraints from source-table
WITH HEADINGS uses headings from source-table
WITH HELP TEXT uses help text from source-table