Oracle View Schema
Database
1
Posts
1
Posters
0
Views
1
Watching
-
I'm trying to use both OleDbClient and OracleClient to get Tables/Views Schema but some data is incorrect. only OracleDataReader.GetSchemaTable(), retrieves some correct data but still I have the following problems: 1- For views, BaseTableName is the view name not really the name of base table of the view 2- Also BaseColumnName is the column name in the view not in the base table 3- I cannot find IsAutoIncrement or IsReadOnly columns in the schema table 4- Some data are incorrect with views only, such as IsKey: IsKey is false for Primary Key columns, although it's retrieved correctly if I'm getting schema of table directly not schema of the view can anybody helps me??