Naming a Table Constraint

A table constraint is a named check that enforces data requirements of check parameters.

Whenever you place a data restriction on a table, a constraint is created automatically. You have the option of specifying a name for the constraint. If you do not, the database creates a default constraint name automatically.

This name helps you to identify and customize a table constraint in scripts for database creation and modification.

  1. Double-click a table in the diagram to display its property sheet, and click the Check tab.
  2. Click the User Defined button to the right of the Constraint Name box, and type changes to the constraint name in the Constraint Name box.
    Note:

    You can always return to the default constraint name by re-clicking the User-Defined button.

  3. Click OK.

For more information, see Check Parameters (CDM/LDM/PDM).