ORACLE 数据库中查看所有表的外键信息SQL

* 博客文章部分截图及内容来自于学习的书本及相应培训课程以及网络其他博客，仅做学习讨论之用，不做商业用途。
* 如有侵权，马上联系我，我立马删除对应链接。
* @author Alan
* @Email no008@foxmail.com

ORACLE 数据库中查看所有表的外键信息SQL

SELECT
	a.OWNER "外键拥有者",
	a.Table_Name "外键表",
	c.Column_Name "外键列",
	b.OWNER "主键拥有者",
	b.Table_Name "主键表",
	d.Column_Name "主键列",
	c.Constraint_Name "外键名",
	d.Constraint_Name "主键名"
FROM
	user_Constraints a,
	user_Constraints b,
	user_Cons_Columns c,-- 外键表
	user_Cons_Columns d -- 主键表
WHERE
	a.r_Constraint_Name = b.Constraint_Name
	AND a.Constraint_Type = 'R'
	AND b.Constraint_Type = 'P'
	AND a.r_Owner = b.OWNER
	AND a.Constraint_Name = c.Constraint_Name
	AND b.Constraint_Name = d.Constraint_Name
	AND a.OWNER = c.OWNER
	AND a.Table_Name = c.Table_Name
	AND b.OWNER = d.OWNER
	AND b.Table_Name = d.Table_`Name`
	order by a.Table_Name asc;