Default Constraints

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

Access     Right-click on Table | Operations

Create a Default Constraint

Step

Action

1

On the Operations Properties dialog, in the Name field, type the new operation name in the format 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 on Column in the left-hand 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.