Constraint between tables

• MegaDBA

  Hall of Fame

  Points: 3518

  More actions

  December 19, 2003 at 7:26 am

  #59051

  Can we create a constraint between tables in 2 separate databases?

  TIA,

  aurora01

  
  

  Aurora

• K. Brian Kelley

  SSC Guru

  Points: 114642

  More actions

  December 19, 2003 at 8:16 am

  #487225

  A foreign key constraint, no. You'll have to use triggers to manage relational integrity.

  K. Brian Kelley, GSEC

  http://www.truthsolutions.com/

  Author: Start to Finish Guide to SQL Server Performance Monitoring

  http://www.netimpress.com/

  K. Brian Kelley
  @kbriankelley

• Jonathan

  SSC-Insane

  Points: 20427

  More actions

  December 19, 2003 at 8:19 am

  #487227

  You can't use a FOREIGN KEY constraint, but you can create a CHECK constraint with a UDF that references objects in another database.

  --Jonathan

  
  
  --Jonathan