Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> SQL query for foreign keys?

SQL query for foreign keys?

From: Stan Brown <stanb_at_panix.com>
Date: 23 Jul 2001 18:03:19 -0400
Message-ID: <9ji6v7$j2m$1@panix2.panix.com> 






Given a table name column name pair, what query can I run against the
system tables to find out:



    
  
  1.   If it has a foreign key.
  
  2.   If so, what the table name column name pair that it's key resieds in?



Received on Mon Jul 23 2001 - 17:03:19 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US