Add or Modify Check Constraint

Go Up to Available object actions by DBMS

This action opens a Check Constraints Editor or Check Constraints Wizard.

Platform Availability

• DB2 LUW
• DB2 z/OS
• MySQL
• ORCL
• SQL SVR
• SYB ASE

To Open the Check Constraint Editor or Check Constraint Wizard

1. On the Navigator/Explorer, right-click the Check Constraints node, and then select Create.
2. Use the following table as a guide to creating or editing the constraint before clicking Execute. Note that settings available varies by DBMS type.

Step	Setting	Task
Definition	Table Owner or Table Schema	Select the owner of the table for which the check constraint is to be created.
	Table or Table Name	Lets you select where you want to place the check constraint.
	Name	Lets you type the name of the constraint, which can be up to 30 characters long and must be unique across the entire database.
	Enabled or Enforced	Enables or disables the check constraint.
	Not for Replication	Enabling this feature ensures that the constraint is not enforced if the table is replicated for another database.
	Check Condition	Type the check constraint condition. As a convenience, use the Table Columns button to paste in column names as part of the condition.
Comment		Lets you type a comment.
DDL View		Preview the DDL generated by your choices.