Chapter 3 Building Conceptual Data Models

Cascading updates to columns associated with the domain

When you modify data types associated with a domain, an update confirmation box is displayed asking if you want to modify the columns currently using the domain.

To modify domain properties:

1. Open the property sheet of a domain and edit its properties as required.
2. Click OK.
   
   If the domain is used by one or more columns, an update confirmation box is displayed asking if you want to modify domain properties for the columns using the domain.

The Data Type check box is selected or not according to the options set to enforce non-divergence from a domain (see Enforcing non-divergence from domains in a CDM).

1. Select any other properties that you want to update (Check, Rules, Mandatory, Profile) for all columns using the domain.
2. Click one of the following buttons:
   
   
   • Yes - The columns currently using the domain are modified according to the update
   • No - The columns currently using the domain are not modified according to the update but the current modification is accepted if domain divergence is allowed in the model options (see ).
   • Cancel - The update is cancelled and nothing is changed

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