Post reply

Get list of Child Table and Foriegn Keys without SP_FKEYS

  • May 29, 2007 at 3:42 am

    #92407

    Hello all,

    I need to get a list of the child tables for a given parent table and if possible the foreign keys. Here's the catch, I can't use FOREIGN KEY constraints and use triggers for RI instead and therefore I can't use SP_FKEYS

    Much Thanks,

    Steve Dingle

  • May 29, 2007 at 9:54 am

    #709407

    I think you could use sp_helptrigger to determine the name of the trigger for a given parent table, then use sp_depends to see the dependencies of the trigger.

    Greg

    Greg

  • May 29, 2007 at 10:13 am

    #709412

    Thanks Greg will give that a shot

    Much Thanks,

    Steve Dingle

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

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