For more information about check constraint syntax, see the reference information that is included with each database product. There might be differences between the IBM data server syntax and the syntax for other vendors.
Property | Description |
---|---|
Name | Specifies a name for the object. |
Label | Specifies a label that is displayed in visual diagrams. |
Enforced | Specifies that the check constraint is enforced. Constraints that are not enforced are informational, and they are only used for query optimization. Informational constraints are not supported by every database manager. Specify this property unless the table data is independently known to conform to the constraint. Query results might be unpredictable if the data does not actually conform to the constraint. |
Expression | Type an SQL expression for the check constraint. |
Validate | Validates the SQL expression in the Expression field. |