November 8, 2006 at 2:59 pm
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
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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy