Please note : This help page is for an older version of Enteprise Archtiect. The latest help can be found here.

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.