Check constraint properties

Properties for IBM® data server check constraint objects

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.

General page
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.
Documentation page
Specifies user-supplied information about the object.
Annotation page (in edit mode only)
Add, modify, or delete properties.
Related information
Check constraints, Version 9.1 for z/OS
Adding check constraints, DB2 Version 9.1 for Linux, UNIX, and Windows
Using the check constraint, IBM Informix Dynamic Server v10.0

Feedback