Default Constraints

Default Constraints only apply to SQL Server, and are supported to maintain compatibility with earlier versions.

Access:     Table context menu | Operations

Use to:

  • Create a default constraint

How to:

To create a Default Constraint using the Operations Properties dialog, follow the steps below:

Step

Action

1

In the Name field, type the new operation name DF_<ColumnName>

The DF_ is optional, but helps to identify the operation

2

In the Stereotype field type or select the value default

3

Click on the Save button

4

In the Operations list, click on the default operation name, then click Column in the left panel

5

Select the appropriate column from the Column Name drop down list

6

Click on Behavior in the left-hand panel

7

In the Initial Code field, type the default value

8

Click on the Save button