--查询table(TGP_RPT_GPR0042MY_D1)关联的所有外键
select fk_col.constraint_name, fk_col.table_name, fk_col.column_name
from user_constraints pk, user_constraints fk, user_cons_columns fk_col
where pk.table_name = 'TGP_RPT_GPR0042MY_D1'
and pk.constraint_type = 'P'
and fk.r_constraint_name = pk.constraint_name
and fk_col.constraint_name = fk.constraint_name
order by 2, 3;
查询某个table关联的所有外键
最新推荐文章于 2023-09-04 22:42:22 发布