I developed like below.Any experts query ....please send.selecttable_name,constraint_namefrom user_cons_columns where column_name=(select a.COLUMN_NAME from user_cons_columns a,user_constraints bwhere a.TABLE_NAME=b.TABLE_NAME and b.constraint_type in ('P')and a.TABLE_NAME='DEPT')and constraint_name like '%FK%'

asheesh

• Jun 2nd, 2012

select table_name from USER_CONSTRAINTS where r_constraint_name= (select CONSTRAINT_NAME from USER_CONSTRAINTS where table_name=INPUT_PARENT_TABLE and CONSTRAINT_TYPE=P) and CONSTRAINT_TYPE=R;

sen_sam86

 Profile Answers by sen_sam86 Questions by sen_sam86

• Aug 18th, 2009

Try this script, Example SELECT child.table_name AS "TABL_NAME_2", 'Is Parent Of' AS ...

Answer Question  Select Best Answer