sqltoadverticatoad-data-point

SELECT all from v_catalog.columns not showing ALL columns

I'm running the following statement because I'm looking for a particular column:

SELECT * FROM v_catalog.columns

The result of this query only shows me columns for five schemas.

On the other hand, the dropdown in Toad's Object Explorer will display over 30 table schemas. I would think that all these tables would be displayed in the query above. I have read access to one of the tables that's not being displayed in the select above, so it's not permission issues.

Am I missing something?

Solution

  • I ended up using VIEW_COLUMNS. Also, the column names would all need to be upper case. It worked.