SQL to list out all the objects (tables) which refrence to a agiven table.
636764Feb 4 2009 — edited Feb 4 2009Hi All -
I want to write a SQL which will list out all the objects (tables) which refrence to a given table.
For e.g.
Lets say Table B refrence to table A.col1 and table C ref to table A.col2
Now I want a SQL which will following output:-
TABLE Refrenced by Column
A B B.col1
A C C.col4
Thanks!!!