Chapter 3 Building Physical Diagrams

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.

To name a column constraint:

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.
   
   
      Undo changes to a constraint name
   You can always return to the default constraint name by clicking the User-Defined button.
   
   
3. Click OK in each of the dialog boxes.

Copyright (C) 2007. Sybase Inc. All rights reserved.