|
|
| ajay.bisht@gmail.com 2006-03-22, 7:25 am |
| I am hving a parent table t_try1.and there are three chid tables linked
to it (ie foreign key ref.).Is there any query with help of which i can
find the name of all the child tables linked to that particular parent
table..Actually there are 150 tables in the database.I hv been given
the task to find all the child tables of a particular table.Im using
pl/sql developer.
| |
|
| You could use something like this one:
SELECT DISTINCT A.TABLE_NAME KIND,
B.TABLE_NAME PAPA
FROM USER_CONSTRAINTS A,
USER_CONSTRAINTS B
WHERE A.R_CONSTRAINT_NAME =3D B.CONSTRAINT_NAME(+)
AND B.TABLE_NAME =3D 'T_TRYL'
AND A.TABLE_NAME !=3D B.TABLE_NAME
Regards,
J=F6rg
| |
| DA Morgan 2006-03-22, 8:25 pm |
| ajay.bisht@gmail.com wrote:
> I am hving a parent table t_try1.and there are three chid tables linked
> to it (ie foreign key ref.).Is there any query with help of which i can
> find the name of all the child tables linked to that particular parent
> table..Actually there are 150 tables in the database.I hv been given
> the task to find all the child tables of a particular table.Im using
> pl/sql developer.
Morgan's Library at www.psoug.org
Click on Constraints
Scroll down to the queries near the bottom of the page.
--
Daniel A. Morgan
http://www.psoug.org
damorgan@x.washington.edu
(replace x with u to respond)
| |
| ajay.bisht@gmail.com 2006-03-23, 3:26 am |
| Got it Buddy!!!Tkx a lot
|
|
|
|