Naming a Column Constraint

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

Whenever you place a data restriction on a column, it generates a constraint automatically. You have the option of specifying a name for the constraint. If you do not specify a name for the constraint, PowerDesigner creates a default constraint name automatically.

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

  1. Open the property sheet of a column and click the Additional Checks tab.
  2. Type changes to the constraint name in the Constraint Name box.

    The User-Defined button at the end of the box is pressed automatically.

    Note:

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

  3. Click OK in each of the dialog boxes.