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

SQL/MX Statements
HP NonStop SQL/MX Reference Manual—523725-004
2-82
Syntax Description of CREATE TABLE
ANSI SQL-99 standard: NO ACTION referential action means that
the referential check is made at the end of the SQL statement. An error is
raised when the referential constraint is violated.
NonStop SQL/MX does not support NO ACTION referential action in the
way it is specified by ANSI SQL-99. However, you can change NO
ACTION's behavior to be the same as RESTRICT by setting an
appropriate value for the Control Query Default
REF_CONSTRAINT_NO_ACTION_LIKE_RESTRICT. Options for this
attribute are:
referenced-table is the table referenced by the foreign key in a referential
constraint. referenced-table cannot be a view. referenced-table
cannot be the same as table.
column-list specifies the column or set of columns in referenced-table
that corresponds to the foreign key in table. The columns in the column list
associated with REFERENCES must be in the same order as the columns in
the column list associated with FOREIGN KEY. If column-list is omitted, the
referenced table’s PRIMARY KEY columns are the referenced columns.
A table can have an unlimited number of referential constraints, and you can
specify the same foreign key in more than one referential constraint, but you must
define each referential constraint separately. You cannot create self-referencing
foreign key constraints.
Publish/Subscribe's embedded update and embedded delete statements are not
allowed on tables with referential integrity constraints:
STORE BY store-option
specifies a set of columns on which to base the clustering key. The clustering key
determines the order of rows within the physical file that holds the table. The
storage order has an effect on how you can partition the object.
store-option is defined as:
PRIMARY KEY
bases the clustering key on the primary key columns. This store option
requires that the primary key is NOT DROPPABLE. If the primary key is
defined as DROPPABLE, NonStop SQL/MX returns an error.
OFF SQL issues an error.
SYSTEM SQL issues warning 1302, indicating that it will behave like
RESTRICT. This is the default value.
ON Makes NO ACTION behave like RESTRICT, without warnings or
errors.