Get Parent/Child, Foreign Key info without SP_FKEYS

[SteveDingle]

Heya All,

SS2K. I need to get "dependency"information, like a list of all the children and also the columns that would make up the foreign key.

I cannot use SP_FKEYS because for some tables I am unable to use the FORIEGN KEY constraint. instead I am using triggers for RI.

Thanks

Toodles,
Steve Dingle

http://www.dsbusinesssolutions.co.uk

D&S Business Solutions Ltd

 

[LNBruno]

Maybe something here would help?

faq183-6649

< M!ke >

 

[SteveDingle]

Thanks LNBruno,

Looks like a very useful but I doesn't gets me what I need. The more I look into the more I think the problem is that if you don't/can't use the FORIEGN KEY constraint, the information is just not store anywhere. Since you don't "define" what a trigger is going to do only that it triggers on an update/insert/delete you aren't defining a relationship.

That's what I think I need. A way to define a relationship between tables without having to build a constraint and then access that information. Doesn't seem to exist. Might have to use extended properties

Toodles,
Steve Dingle

http://www.dsbusinesssolutions.co.uk

D&S Business Solutions Ltd