SQL Server Cutom Data types

[Sanjai]

Hi
I’m trying to create a database platform specific physical implementation model (SQL Server).  I have come across following issues with custom data types. Just wondering whether the community can help


1.      I tried to create a custom data type PatientID of type Varchar(16), the generated DDL gives PatientID PatientID(0) NOT NULL – which is not correct syntax
2.      If I derive a custom data type out of int (say SID). Can I attached an auto number to this since it’s a type of int. at present it is disabled.

Thanks
sanjai