Assigning a Default to a Column or a Domain

You can select a default from the list of defaults and assign it to a column or a domain from the Standard Checks tab of the 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.

    Alternatively, you can type a default value in the listbox; this does not create a default object in the model, it only assigns a default value for the current column or domain. If you type a name that already exists in the list, the default object is attached to the column or domain.

  3. Click OK in each of the dialog boxes.
    Note: To generated a default object in your database, you must use the Rebuild Default command (see Rebuilding Defaults).