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 ????
Printable View
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 ????
[QUOTE] Can I Define Unique key + Not Null is Equal to Primary key ????[/QUOTE]
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.....