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.