Constraint Definition
Use the constraint definition portion of CREATE TABLE
for these purposes:
- To declare a name for the constraint
- To set a constraint to disabled, enabled, or filtering mode.
This syntax fragment is part of the Single-Column Constraint Format and the Multiple-Column Constraint Format.
Constraint Definition |--+------------------------+-----------------------------------> '-CONSTRAINT--constraint-' >--+----------------------------------+-------------------------| | .-ENABLED----------------------. | '-+------------------------------+-' +-DISABLED---------------------+ | .-WITHOUT ERROR-. | '-FILTERING--+-WITH ERROR----+-'
| Element | Description | Restrictions | Syntax |
|---|---|---|---|
| constraint | Name of constraint | Must be unique for the table among index and constraint names | Identifier |