Show TOC

Rebuilding DefaultsLocate this document in the navigation structure

You can generate default objects from default values entered into the Default list on the Check Parameters tab of a column or domain property sheet. The new default objects replace the previously entered values, and can be reused with other columns and domains.

Context

Note If your model's DBMS does not support default objects and you have assigned default values to domains then, if you change to a DBMS that does support default objects, an object will be created for each value. Default values assigned to columns will not be converted into objects. When changing from a DBMS that supports default objects to one that does not, default objects are converted into default values.

Procedure

  1. Select Start of the navigation path Tools Next navigation step Rebuild Objects Next navigation step Rebuild Defaults End of the navigation path, and enter the appropriate options:

    Option

    Description

    Domains / Columns
    Specifies the naming conventions for defaults applied to domains and columns respectively, which are both, by default, D_%.U:VALUE%. You can specify different names for each type of default, and use the following variables:
    • %DOMAIN%, %COLUMN%, %TABLE% - Code of the domain, column, or table using the default.

    Mode
    Specifies the type of rebuild. You can select either or both of:
    • Reuse default with identical value – Creates a single default for each value, even if the value is found in multiple columns and domains. If you deselect this option, multiple defaults may be created with the same value.
    • Delete and rebuild – Delete and rebuild all existing default objects.
  2. [optional] Click the Selection tab to specify which domains and tables to search for defaults to rebuild.
  3. Click OK. If you selected the Delete and Rebuild mode, a confirmation box asks you to confirm your choice. Click Yes to confirm the deletion and rebuild of the selected defaults.