``
select distinct allc1.table_name 表名,
allc1.constraint_name 外键名,
dcc1.column_name 约束字段,
--dccm.comments 字段中文名,
allc2.table_name 外键关联表,
dcc2.column_name 外键关联字段,
dtc.comments 表中文名
--allc2.constraint_name 对应主键
from dba_constraints allc1
Join dba_constraints allc2
on allc1.r_constraint_name = allc2.constraint_name
join dba_cons_columns dcc1
on dcc1.constraint_name = allc1.constraint_name
join dba_cons_columns dcc2
on dcc2.constraint_name = allc2.constraint_name
Join dba_tab_comments dtc
on allc2.table_name = dtc.table_name
--Join dba_col_comments dccm on dcc.column_name = dccm.column_name
where allc1.table_name = 'POL_MAIN'
and allc1.constraint_type = 'R';
查询外键关联表(父表)
最新推荐文章于 2021-03-09 10:59:25 发布