
January 12th, 2005, 02:27 AM
|
|
Registered User
|
|
Join Date: Dec 2004
Posts: 24
Time spent in forums: 2 h 7 m 59 sec
Reputation Power: 0
|
|
|
Reg. foreign key tree
Hi,
In one of my projects I have a requirement where I get all the dependent tables for a particular Table.
For Example, say Table A has foriegn key relations to B, C,D
Say Table B has foriegn key relation to E,F,G
Say Table C has Foreign key relation to H,I,G
Table E has foreign Key relation to U, V, W
Table U has foreign key relation to X, Y, Z
Then, is there any way, where if I give Table A, I will get the list of all the tables referencing it (directly or indirectly). The result should retrun all the tables - B, C, D, E, F, G, H, I, G, U, V, W, X, Y, Z
Any system function or piece of code would be great.
Thanks
oursmp
|