SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
C-155
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 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 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 these 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 } |}
[| FORMAT {1|2} |]
{| { 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