Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle relations via ODBC / ORA OLE DB Provider
"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