Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Searching user tables for a column name 1

Status
Not open for further replies.

5chw4r7z

MIS
Apr 25, 2003
9
US
Is there a way to search the user_tables for a column name without doing a desc on each one indiviualy. I have 350 tables and i need to find which table has a certain column.
 
Code:
select c.table_name
from   sys.all_tab_columns c
where  c.column_name = 'MY_COLUMN' 
and    c.owner = 'MY_SCHEMA'

Code:
select * from Life where Brain is not null
Consultant/Custom Forms & PL/SQL - Oracle 8.1.7 - Windows 2000
[sup]When posting code, please use TGML to help readability. Thanks![sup]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top