Chapter 3 Building Physical Diagrams

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.

Steps To name a table constraint:

  1. Double-click a table in the diagram to display the table property sheet.
  2. Click the Check tab to display the Check page listing all check parameters defined for the table.
  3. Click the User Defined button at the end of the Constraint Name box.
  4. Type changes to the constraint name in the Constraint Name box.

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

  5. Click OK.

 

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