Check constraint properties

Properties for IBM® data server check constraint objects

For more information about specific syntax, see the reference information that is included with each database product. Syntax definitions for some database vendors or versions might differ from the following descriptions.

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.

Feedback