A Foreign Key constraint can be defined to reference the columns of Non Primary key column ?

 Posted by PandianS on 9/8/2010 | Category: Sql Server Interview questions | Views: 2995 | Points: 40
Answer:

Yes. A FOREIGN KEY constraint does not have to be linked only to a PRIMARY KEY constraint in another table; it can also be defined to reference the columns of a UNIQUE constraint in another table.

A FOREIGN KEY constraint can contain null values.


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response