找表主外键SQL代码

 select 　 　 　 　 　 　 　

A.TABLE_NAME as OWNER,

B.TABLE_NAME as REFER

from

USER_CONSTRAINTS A,

USER_CONSTRAINTS B

where

A.CONSTRAINT_TYPE = 'R' and

A.R_CONSTRAINT_NAME = B.CONSTRAINT_NAME

order by

A.TABLE_NAME,

B.TABLE_NAME;