can unique key be used as foreign key? What is the difference between Primary key and unique key?

Henil Mewada

• Oct 6th, 2015

Primary key can be only one in table and more than one unique key in one table. Primary key can be never allow null value and unique key can be candidate key.

Deepak Khare

• Jan 23rd, 2012

Answer is Yes. You can find details here http://msdn.microsoft.com/en-us/library/ms175464(v=SQL.90).aspx

Answer Question  Select Best Answer