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: 4970 | Points: 40

Post |

Interview FAQs |

Exclusive Questions |

Interview Home

Answer:

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