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