Creating Models › Creating a Physical Model › Constraints › Default Value Editor

Default Value Editor

Using the Default Value Editor, you can create a server default value for a column. The server default value you select for a column is usually the most common value that you store in a column.

In the Table Column Editor, when you click the button in the Default drop-down of the Default option on the Constraint tab, the Default Value Editor opens. It is also opened when you click the New button to create a new default value from the Table Column Editor.

The Default Value Editor provides the following options:

Previous

Positions the editor on the previous default value in the Navigation Grid.

Next

Positions the editor on the next default value in the Navigation Grid.

Sort

Sorts the default values by alphabetic or reverse alphabetic order. You select the method you want using the drop-down menu that opens after you click the Sort button. Visual cues are provided for how the default value list is currently sorted:

Specifies that the default value list is sorted in alphabetic order.

Specifies that the default value list is sorted in reverse alphabetic order.

New

Creates a new default value that becomes the current object in the editor.

Delete

Deletes the selected default value.

Help

Opens online help for the editor.

Lets you filter a very large list of tables in the Navigation Grid to quickly locate the table for which you need to view or define properties.

Physical Name

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

Physical Only

Specifies whether the default value is suppressed from a logical model and appears in a physical model only.

<Database> Tab

Displays the server default value for the selected default name. Enter or edit the default value that you want to generate in the schema script.

Note: This describes the basic option available for all target servers. There can be more options available depending on your target server. Consult your specific target server documentation for more information about using these options.

Comment

Lets you enter a comment for the default value.

Where Used

Lets you view where the default value is used in the model.

UDP

Lets you specify a user-defined property value for the default value.

Notes

Lets you view history information and view or edit user notes.

Note: After you create a server default or initial value, you can assign it to one or more columns using the Table Column Editor.