Assigning a Default to a Column or a Domain

You can select a default from the Default list on the Check Parameters tab of a column or domain property sheet.

  1. Open the property sheet of a column or a domain, and click the Standard Checks tab (see Setting Data Profiling Constraints).
  2. Select a default in the Default list in the Value groupbox.

    You can, alternatively, enter a default value in the listbox. The value entered is assigned as a default value for the column or domain, but a default object is not created in the model, and the default cannot be reused elsewhere. If you enter a name that is already in the list, the relevant default object is attached to the column or domain.

    Note: You can create default objects for reuse from default values, through the Rebuild Default command (see Rebuilding Defaults).
  3. Click OK to return to your model.