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, right-click the Check Constraints node and select Create.
2. Use the following table as a guide to creating or editing the constraint. Note that settings available varies by DBMS type.

Step	Settings and tasks
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. Finally, use the Execute button to create the check constraint.