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 -> Re: Oracle relations via ODBC / ORA OLE DB Provider

Re: Oracle relations via ODBC / ORA OLE DB Provider

From: Guido Konsolke <GK_at_oblivion.com>
Date: Tue, 3 Feb 2004 12:36:15 +0100
Message-ID: <1075806895.988763@news.thyssen.com>


"Jochen Rieseberg" wrote...
> Hello all!
>
> i have to read out from MS Access / Visual Basic all tables, fields
and
> relations of a big Oracle database using ADOX and the Oracle OLE DB
> Provider. No problem with tables and fields so far, but i do not
know how to
> get the relations / foreign table / foreignkey. Can anybody help
me??
>
> Jochen Rieseberg
> www.rieseberg.de
>

Hallo Jochen,

please check out the data dictionary. Hint: USER_CONSTRAINTS. You can find information in the ORACLE SQL REFERENCE that matches your rdbms version.

hth,
Guido Received on Tue Feb 03 2004 - 05:36:15 CST

Original text of this message

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