ALLBASE/SQL Reference Manual (36216-90216)

302 Chapter10
SQL Statements A - D
ALTER TABLE
CREATE TABLE statement.
CLUSTERING ON CONSTRAINT specifies that the named unique or referential constraint
specified within the Column Definition be managed
through a clustered index structure rather than
nonclustered. The unique constraint's unique column list,
or referential constraint's referencing column list, becomes
the clustered key.
ConstraintID specifies the unique or referential constraint on which
clustering is to be applied. If not specified, the primary key
of the table is assumed. The
ConstraintID must be for a
constraint being added with the ALTER TABLE statement.
SQL Syntax—AddConstraintSpecification
ADD CONSTRAINT ({ UniqueConstraint
ReferentialConstraint
CheckConstraint }[,...])
[CLUSTERING ON CONSTRAINT [ ConstraintID1 ]]
Parameters—AddConstraintSpecification
UniqueConstraint defines a unique constraint being added. This parameter
is described under the CREATE TABLE statement.
ReferentialConstraint defines a referential constraint being added. This
parameter is described under the CREATE TABLE
statement.
CheckConstraint defines a check constraint being added. This parameter is
described under the CREATE TABLE statement.
CLUSTERING ON CONSTRAINT specifies that the named unique or referential constraint
be managed through a clustered index structure rather
than nonclustered. The unique constraint's unique column
list, or referential constraint's referencing column list,
becomes the clustered key.
ConstraintID1 specifies the unique or referential constraint name on
which clustering is to be applied. If not specified, the
primary key of the table is assumed.
ConstraintID1
must be for a constraint being added with the ALTER
TABLE statement.
SQL Syntax—DropConstraintSpecification
DROP CONSTRAINT {( ConstraintID [,...])
ConstraintID }
Parameters—DropConstraintSpecification
ConstraintID is the name of the constraint optionally defined when the