查询主外键关系

Select b.table_name 主键表名,
       b.column_name 主键列名,
       a.table_name 外键表名,
       a.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

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/22123669/viewspace-677974/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/22123669/viewspace-677974/