Post reply

Setting referential integrity across distinct databases

  • October 27, 2009 at 11:36 pm

    #211467

    Is it possible to set referential integrity between two tables which are part of different databases?

    For ex:

    suppose dim_calendar table with Time_Key as primary key is in database A

    fact_sales with period_key as foreign key is in database B

    then is it possible that B.fact_sales(period_key) references A.dim_calendar(time_key)?

    Thanks

  • October 28, 2009 at 12:04 am

    #1071556

    No.Cross database foreign key reference is not supported.

    ..

  • October 28, 2009 at 1:14 am

    #1071564

    You'll need to use triggers to do this.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply