Post reply

Lookup Tables

  • November 8, 2006 at 2:59 pm

    #367988

    I have about 100 lookup tables in a database and I want to identify the keys (used by other core tables) to look up those tables up. How can I go about finding those keys?

  • November 8, 2006 at 3:18 pm

    #670726

    I'm not quite sure what you mean by "keys", however if you are talking about referential integrity and determining which columns have a foreign key relationship to that table then you can use the sp_helpconstraint procedure to return this information.

    Ex. sp_helpconstraint tablename

     

     

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

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