September 23, 2003 at 6:23 pm
Hello all,
Is there a way to identify Junction tables in a database using T-SQL?
-Isaiah
September 25, 2003 at 5:05 am
Junction? As in a many to many relationship table?
Andy
September 25, 2003 at 10:22 am
YES!!!!
I want to be able to programatically identify this kind of table. I can identify One-Many (easy) and One-One but many-many split to 2 One-Many seems to be challenging.
-Isaiah
September 26, 2003 at 5:43 am
You're going to use TSQL or DMO to do it? If TSQL, you should repost in a different forum to get more replies. If DMO, just off the cuff I can't think of any easy way, you'd have to scan each object to get the foreignkeys, then start looking for a object that....well, was the target of the fkey from two different tables?
Andy
Viewing 5 posts - 1 through 4 (of 4 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