Online Documentation for SQL Manager for SQL server

Table Type Constraint dialog


The Table Type Constraint dialog allows you to specify the UDT Primary/Unique Key properties.

 

UDT Editor - Managing UDT Primary_Unique Keys - Table Type Constraint dialog

 

 

Constraint Type

This group allows you to specify the UDT constraint type:

RadioButton Primary Key

Specifies a primary key constraint.

RadioButton Unique Key

Specifies a unique key constraint.

 

Options

 

CheckBox Clustered

If this option is selected, the logical order of the key values determines the physical order of the corresponding rows in a table.

 

CheckBox Ignore duplicate keys

This option specifies the error response to duplicate key values in a multiple-row insert operation on a unique clustered or unique nonclustered constraint.

 

 

Columns

To specify field(s) for the UDT constraint, you need to move it from the Available Columns list to the Selected Columns list. Use the Items - Move to Selected Items - Move all to Selected Items - Move to Available Items - Move all to Available buttons or drag-and-drop operations to move the fields from one list to another.

 

To change the sorting order for a field, select the field in the Selected Columns list and change the Order value (ascending/descending).