Constraint Definition

Enterprise Edition Home | Express Edition Home | Previous Page | Next Page SQL Statements > ALTER TABLE >

Constraint Definition

In Dynamic Server, use the Constraint Definition portion of the ALTER TABLE statement to declare the name of a constraint and to set the mode of the constraint to disabled, enabled, or filtering.

In Extended Parallel Server, use the Constraint Definition portion of the ALTER TABLE statement to declare the name of a constraint.

Constraint Definition:
 
|--+------------------------+----------------------------------->
   '-CONSTRAINT--constraint-'
 
>--+-----------------------------------------+------------------|
   |  (1)                                    |
   '--------+------------------------------+-'
            | .-ENABLED--.                 |
            +-+-DISABLED-+-----------------+
            |            .-WITHOUT ERROR-. |
            '-FILTERING--+-WITH ERROR----+-'

Notes:

Dynamic Server only

Element	Description	Restrictions	Syntax
constraint	Name declared here for the constraint	Must be unique among the names of indexes and constraints in database	Identifier, p. Identifier

For more information about constraint-mode options, see Choosing a Constraint-Mode Option (IDS).