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. Select Model→Columns to display the List of Columns.
2. Click a column in the list.
   
   An arrow appears at the beginning of the line.
3. Double-click the arrow at the beginning of the line.
   
   or
   
   Click the Properties tool.
   
   The column property sheet appears.
4. Click the Additional Checks tab.
   
   The Additional Checks page appears.
5. 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.
   
   
6. Click OK in each of the dialog boxes.

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