Can a FOREIGN KEY constraint reference the column in tables in the different database ?

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

A FOREIGN KEY constraint can reference columns in tables in the same database or within the same table.

The following error occurred when we try to reference the different database
"The object name contains more than the maximum number of prefixes. The maximum is 2."

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response