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


   | .-ENABLED----------------------. |   
     |            .-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