Get Oracle database schema information using ODP.NET

[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

 

[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