Rebuilding Defaults

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.

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.
  1. Select Tools > Rebuild Objects > Rebuild Defaults, 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.