如何查看一个主键被引用的其它表 [复制链接]

--查看表 ETS_TICKET 被其它表引用的外键和表明

select uc.constraint_name,uc.table_name,uc.r_constraint_name,uc.status from user_constraints uc
where uc.constraint_type='R'
--and uc.status='ENABLED'
and uc.r_constraint_name in
(
select c.constraint_name from user_constraints c where c.constraint_type='P'
and c.table_name='ETS_TICKET'
)

/*查看用户所有外键*/

select /*+ all_rows */ t.table_name,t.constraint_name, s.table_name ref_table,s.column_name ref_column from user_constraints u,
(select uc.table_name,uc.constraint_name ,uc.r_constraint_name from user_constraints uc where uc.constraint_type='R' ) t,
(select c.constraint_name,c.table_name,c.column_name from user_cons_columns c) s
where t.r_constraint_name=u.constraint_name
and u.constraint_name=s.constraint_name
order by t.table_name;