sql server 2005 User defined datatype and PrimaryKey
-
Hello, I was exploring user defined datatypes in sql server 2005. I tried making this type, a primary key but I am afraid that option is disabled. Now is this not possible or are there any properties that needs to be set first ? Looking for reply.
Regards, Aims
-
Hello, I was exploring user defined datatypes in sql server 2005. I tried making this type, a primary key but I am afraid that option is disabled. Now is this not possible or are there any properties that needs to be set first ? Looking for reply.
Regards, Aims
I found the following on MSDN: In SQL Server 2005 SP1, UDT fields must use native serialization or be persisted in order to be indexed. and You can create indexes on CLR user-defined type columns if the type supports binary ordering. I don't really think that UDTs are really meant to be primary keys.