Q

Finding names of tables with a certain column

I want the names of different tables containing a column "purposeid" in the database "banksoft."

I want the names of different tables containing a column "purposeid" in the database "banksoft."
Query DBA_TAB_COLUMNS for this, similar to the following:
SELECT table_name FROM dba_tab_columns
WHERE column_name='PURPOSEID';
This was first published in November 2005

Dig deeper on Oracle database design and architecture

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close