Home Forums SQL Server 2008 T-SQL (SS2K8) FK referencing multiple tables RE: FK referencing multiple tables

  • September 20, 2012 at 4:46 am

    #1539994

    Grant Fritchey (9/20/2012)

    Nope.

    You'd have to write a trigger to do something like that.

    If the insert/update is made by a SP what would be better: change the SP the check if the referenced value exists or write the trigger? If the trigger was used what would be the most appropriate: BEFORE, INSTEAD, FOR or AFTER (don't think AFTER makes any sense here..).

    Thanks,

    Pedro


    If you need to work better, try working less...