文章列表
select
a.owner as "用户名称",
c.table_name as "主键表",
d.column_name as "主键字段",
b.R_CONSTRAINT_NAME as "主键约束",
a.table_name as "外键表",
a.column_name as "外键字段",
a.constraint_name as "外加约束"
from user_cons_columns a,user_constraints b, user ...
http://www.wuleilei.com/