Managing Check Constraints
Check constraints are imported when an object is created using Add from Remote System or Update Schema, or when the Synchronize Structure feature is used. You cannot create these constraints in OneData but can assign a customized message to the constraint after they are imported.
OneData does not support check constraint on SQL Server.
System-generated check constraints (or check constraints starting with sys_) are excluded when using the Update Schema or Synchronize Structure functionality.
To edit an existing Check Constraints
1. On the Menu toolbar, click Define > Objects and select the object in which you want to create unique constraint.
2. Click Structure tab.
3. Click Edit Constraints.
4. Under Check Constraints select the edit icon next to the required constraint.
5. Enter an error message in the Customized Error Message box.
6. Click Save.