--查看表 ETS_TICKET 被其它表引用的外键和表明select uc.constraint_name,uc.table_name,uc.r_constraint_name,uc.status from user_constraints ucwhere 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')