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
Read syntax diagramSkip visual syntax diagramCONSTRAINTconstraintENABLEDDISABLEDFILTERINGWITHOUT ERRORWITH ERROR
Element Description Restrictions Syntax
constraint Name of constraint Must be unique for the table among index and constraint names Identifier