本文提供了一段SQL脚本，用于查询Oracle数据库中特定主表的外键约束信息。通过该脚本，可以获取到与指定主表相关的从表名称及对应列名，帮助开发者更好地理解和维护数据库表间的关系。
select a.table_name ,a.column_name ,b.table_name ,b.column_name
from
(select a.constraint_name,b.table_name,b.column_name,a.r_constraint_name
from user_constraints a, user_cons_columns b
WHERE a.constraint_type='R'
and a.constraint_name=b.constraint_name
) a,
(select distinct a.r_constraint_name,b.table_name,b.column_name
from user_constraints a, user_cons_columns b
WHERE a.constraint_type='R'
and
a.r_constraint_name=b.constraint_name)
b
where a.r_constraint_name=b.r_constraint_name
and b.table_name = '主表名'
order by b.table_name
from
(select a.constraint_name,b.table_name,b.column_name,a.r_constraint_name
from user_constraints a, user_cons_columns b
WHERE a.constraint_type='R'
and a.constraint_name=b.constraint_name
) a,
(select distinct a.r_constraint_name,b.table_name,b.column_name
from user_constraints a, user_cons_columns b
WHERE a.constraint_type='R'
and
a.r_constraint_name=b.constraint_name)
b
where a.r_constraint_name=b.r_constraint_name
and b.table_name = '主表名'
order by b.table_name
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
