Adding a check constraint to a column

  1. Select System > Agency Personalization > Schema Manager.
  2. In the Enhancement Product Families tree, browse to the Columns node for the table definition that you want to add a check constraint to.
  3. Click the Columns node.
  4. Enable editing in the grid and select the column that you want to add a check constraint to.
  5. Under Check Constraints, click Add above the grid.
  6. Type a name for the check constraint in the Name field.
    Infor Public Sector typically uses this naming scheme: CC_[TABLE_NAME]_[COLUMN_NAME]. You can use this naming scheme, or devise one of your own.
  7. Type a common ID for the check constraint in the Common ID field.
    Infor Public Sector typically uses the same information in the Name field.
  8. Type a description of the check constraint in the Description field.
    Descriptions, such as Check Constraint on [COLUMN_NAME], can help you identify the purpose of the check constraint. The information that you type should be helpful to anyone who will be setting up and maintaining Infor Public Sector.
  9. Specify any other information about the check constraint.
    You can select an enumeration collection from the Enum Collection list to indicate that only enumerations defined for the enumeration collection will be valid in this column. You can also type a statement that runs the check constraint in the Statement field. This should be written in SQL.
  10. Click Save to save the check constraint.
    Infor Public Sector assigns a key value to the check constraint and adds the check constraint to the column. The new check constraint is displayed in the 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.
  11. Click Save.