Oracle中查询该表中的主键被哪些表引用的SQL语句:
select c.TABLE_NAME
from all_constraints p, all_constraints c
where p.table_name = '表名'
and p.OWNER = SYS_CONTEXT('USERENV', 'CURRENT_SCHEMA')
and c.OWNER=SYS_CONTEXT('USERENV', 'CURRENT_SCHEMA')
and c.constraint_type = 'R'
and p.CONSTRAINT_NAME = c.R_CONSTRAINT_NAME
Oracle中查询该表中的外键来源于哪些表的SQL语句:
select cl.table_name
from user_cons_columns cl
left join user_constraints c
on cl.constraint_name = c.r_constraint_name
where c.constraint_type = 'R'
and c.table_name = '表名'
Oracle中查询该表被哪些表引用的SQL语句
select c.table_name,
c.constraint_name,
fc.table_name,
fc.constraint_name,
cc.column_name,
fcc.column_name
from user_cons_columns fcc,
user_cons_columns cc,
user_constraints c,
user_constraints fc
where fc.constraint_name = c.r_constraint_name
and fc.constraint_name = fcc.constraint_name
and c.constraint_name = cc.constraint_name
and c.constraint_type = 'R'
and fc.table_name in ('表名') ;
PS:查询owner的SQL语句: select SYS_CONTEXT(‘USERENV’, ‘CURRENT_SCHEMA’) from dual