Column and Field Properties dialog box (Check tab)

Use these options to create check-clause code that enforces constraints for a column.

Microsoft Office Visio automatically generates the check-clause code based on a range or set of values that you specify on this tab. You can customize the automatically generated code.

Automatically generated check-clause code for a column does not appear in the Code window. If you then generate or update a DDL script for your target database, Visio adds the check clause to the Code window for that database.

Show Value/Range

Specifies the ranges or values that will be checked.

From

Type the minimum value that defines the required range to check. If this is left blank, then no minimum value is assumed.

To

Type the maximum value that defines the required range to check. If this is left blank, then no maximum value is assumed.

Value

Type a value to include in a set of values. After each value, click Add.

Add

Click to add the specified set or range of values to the Defined values/ranges box as a new check clause.

Remove

Click to delete the check clause selected in the Defined values/ranges list.

Defined values/ranges

Lists the specified ranges or values.

Show Check Clause Code

Click to show the column's check-clause code.

Physical name

Shows the name of the check-clause code.

Customize

Click to edit the check-clause code.

Check Clause

Shows the check-clause code.