Microsoft SQL Server Creating a UDT with a unique constraint:


Example

CREATE TYPE MyUniqueNamesType as TABLE
(
    FirstName varchar(10),
    LastName varchar(10),
    UNIQUE (FirstName,LastName)
)

Note: constraints in user defined table types can not be named.