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

Home -> Community -> Usenet -> c.d.o.misc -> Referenced Table in Dictionary?

Referenced Table in Dictionary?

From: Christian Dzimalle <cdzimal_at_uni-goettingen.de>
Date: Tue, 14 Sep 1999 14:49:49 +0200
Message-ID: <37DE446C.DA7E7B12@uni-goettingen.de> 





Hi,



is it possible to find out the name of the table that is referenced by
another table using


the dictionary?



take for instance:


CREATE PERSON



(...


 CNR constraint fk_company references COMPANY,
 ...


)



select * from user_constraints; or select * from user_cons_columns;
will tell me the name 'PERSON' but what i need is the tablename
'COMPANY'.


Thanks in advance


Cdzi



P.S. is there an FAQ?
Received on Tue Sep 14 1999 - 07:49:49 CDT












Original text of this message













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