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

Home -> Community -> Usenet -> c.d.o.server -> Re: Report for Extracting Primary and dependant Foreign Keys for a table.

Re: Report for Extracting Primary and dependant Foreign Keys for a table.

From: Ken Geng <ken.geng_at_cbis.com>
Date: 1997/04/01
Message-ID: <33418649.183D@cbis.com>#1/1 







> Does anyone wish to share a script they may have, to identify

> all Foreign keys for a particular Primary key.





SELECT CONSTRAINT_NAME FROM ALL_CONSTRAINTS

WHERE R_CONSTRAINT_NAME = 'PK_????';

Received on Tue Apr 01 1997 - 00:00:00 CST












Original text of this message













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