熱點推薦:
您现在的位置: 電腦知識網 >> 編程 >> Oracle >> 正文

主外鍵約束信息

2013-11-13 22:10:05  來源: Oracle 

  Copy from The Oracle (tm) Users CoOperative FAQ

   Parent / Child / Key Reference

  set pages
set feedback off
spool constraintlog

  col parent format a
col child  format a
col key    format a

  select atable_name         Parent
       btable_name         Child
       column_name          Key
       substr(position) P
from
      user_constraints a user_constraints b user_cons_columns c
where
      nstraint_name = br_constraint_name
and   nstraint_name = nstraint_name
order by ;

  spool off


From:http://tw.wingwit.com/Article/program/Oracle/201311/18360.html
    Copyright © 2005-2013 電腦知識網 Computer Knowledge   All rights reserved.