Previous Topic: Attaching a System Generated Default or Initial Value to a ColumnNext Topic: Modify a Server Default Value


Add a Default or Initial Value for a Target Server

Use the Default Value Editor to add a default or initial value for a target server in a physical model.

To add a default or initial value for a target server

  1. Click Default Values on the Model menu.

    The Default Value Editor opens.

  2. Click the New New icon in property editors to create a new object button on the toolbar.

    A new default value with a default name is added to the Navigation Grid.

  3. Work with the following options:
    Physical Name

    Specifies the physical name of the default value. You can change the name in this field.

    Physical Only

    Specifies that the default value only applies to a physical model.

  4. Click the <database> tab and enter a server default value expression in the Value box. See your server documentation for information on the syntax you can use in a default value expression.
  5. Click Close.

    The default value is added and the Default Value Editor closes.

More information:

Default Value Editor