Please note : This help page is not for the latest version of Enterprise Architect. The latest help can be found here.

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

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.