Get Oracle database schema information using ODP.NET


T

Tony

Does anyone know how to retrieve database schema information (tables,
columns, indexes, etc) using Oracle's ODP.NET provider. It does not support
the OracleConnection.GetSchema() method.

I don't want to have to use another provider such as OleDB or MS's
OracleClient to do this because then I have to support and test multiple
providers.

Tony
 
Ad

Advertisements

M

Miha Markic [MVP C#]

Hi Tony,

One option is to query database. For example to get all columns of all
tables you would use something like:
select * from sys.ALL_TAB_COLUMNS
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top