Get Oracle database schema information using ODP.NET

  • Thread starter Thread starter Tony
  • Start date Start date
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
 
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
 
Back
Top