SQL Server Referential Integrity across Database, Schema?

• HookSQLDBA7

  SSChampion

  Points: 10709

  More actions

  September 19, 2014 at 2:47 pm

  #397376

  In SQL Server 2012 (also 2005 and 2008), can you have Referential Integrity across a Database? Across a Schema?

  Thanks, Kevin

• Lynn Pettis

  SSC Guru

  Points: 442467

  More actions

  September 19, 2014 at 2:52 pm

  #1746832

  Not between databases. Within a database, yes.

  Of course the best way to find out is to test it.