Adding a check constraint to a table definition

  1. Select System > Agency Personalization > Schema Manager.
  2. In the Enhancement Product Families tree, browse to the Check Constraints node for the table definition that you want to add the check constraint to.
  3. Click the Check Constraints node.
  4. Click Add above the grid.
  5. In the Name field, type a name for the check constraint.
  6. In the Common ID field, type an identification code for the table check constraint.
    You will use this common ID throughout Infor Public Sector to identify this check constraint. Although the common ID is not required to be unique, making it unique will help you identify it later.
  7. Type the statement in SQL that defines the check constraint in the Statement field.
  8. Type a description of the check constraint in the Description field.
  9. Click Save.
    Infor Public Sector assigns a key value to the check constraint and adds the check constraint to the table definition. The new check constraint is displayed in the Table Check Constraints grid. Note that changing or deleting an existing check constraint will cause errors wherever it has already been used. If you change or delete a check constraint, you must update any references to it throughout your system.