columns name in a database 1

[cappmgr]

Is the a query that will bring back all of the tables and views that contain a column name?
tyvm,
Marty

 

[SantaMufasa]

Marty,

This query displays owner, table, and column names where any part of the column name matches the prompted string:

select owner, table_name, column_name
from dba_tab_columns
where column_name like upper('%&colname%');

Cheers,

Dave

 

[walkerci]

Marty,

If you don't have privileges to select against dba views such as dba_tab_columns, you can select against user_tab_columns to see column info for tables in the current schema only. You will need to remove the owner column from the query as it is not exposed in the user_tab_columns view.

Charles

 

[carp]

Although you WILL have access to ALL_TAB_COLUMNS, which will show you all of the tables/columns accessible from within the current schema (which, from the schema's perspective, IS the entire database!).