Thread: Unique with NotNull??

Primary key is Clustered Index and not allows null value.
Unique key is NonClustered Index allows one Null value

Can I Define Unique key + Not Null is Equal to Primary key ????

Can I Define Unique key + Not Null is Equal to Primary key ????

Yes, Unique + NOT NULL is equivalent to primary key on a table ,though not explicitly declared. U can always use this column to retrieve a unique row from given table.


HTH

Regards,

I agreed with above answer given by one of our forum member.....