SQL$HELP_OLD72.HLB  —  ALTER  TABLE  Arguments  CONSTRAINT constraint name
    The CONSTRAINT clause specifies a name for the table constraint.
    The name is used for a variety of purposes:

    o  The INTEG_FAIL error message specifies the name when an
       INSERT, UPDATE, or DELETE statement violates the constraint.

    o  The ALTER CONSTRAINT, DROP CONSTRAINT and ALTER TABLE DROP
       CONSTRAINT statements specify the constraint name.

    o  The SHOW TABLE statements display the names of constraints.

    o  The EVALUATING clause of the SET and the DECLARE TRANSACTION
       statements specifies constraint names.

    The CONSTRAINT clause is optional. If you omit the constraint
    name, SQL creates a name. However, Oracle Rdb recommends that
    you always name column and table constraints. The constraint
    names generated by SQL may be obscure. If you supply a constraint
    name with the CONSTRAINT clause, the name must be unique in the
    schema.
Close Help