With the help of ODBC connection, get foreign keys from an oracle db

Question

I want to collect all the Design Information from an Database. It was possible for me to gather the most information, but I cant get Information about Foreign Keys! Is there an possibility to get the Foreign keys from an Oracle DB with an ODBC Connection?!?!?

for example MSSql gives the possibility in C# with:

SqlCommand myCommand = new SqlCommand("sp_fkeys", myConnection);

Is there existing an alternative for ODBC in C#?

Oracle has data dictionary views for all table meta-data. Go google that. — OldProgrammer, Mar 28 '13 at 17:50

score 1 · Answer 1 · answered Mar 28 '13 at 23:38

ODBC has functions that allow database-independent querying of metadata. Start with this page in the ODBC Programmer's Reference and look at the section labeled "Obtaining information about the data source's system tables (catalog functions)". In particular, you're probably interested in the SQLForeignKeys function.

Share and enjoy.

With the help of ODBC connection, get foreign keys from an oracle db

1 Answers1