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.

Read syntax diagramSkip visual syntax diagram
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

Copyright© 2019 HCL Technologies Limited