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.




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.




To specify column(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 columns from one list to another.


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