Home » SQL & PL/SQL » SQL & PL/SQL » SQL question
SQL question [message #19002] Mon, 25 February 2002 08:25 Go to next message
Dave
Messages: 92
Registered: August 1999
Member
Hi there,

I have a problem where by I need to find out which tables a field is in, for example I have a number of tables which contain the field CONTRACT. So is it possible to run a querie against all the tables in the database to find the tables containing this field? And if so how do I do it?

Thanks in advance,
Dave.

Report message to a moderator

Re: SQL question [message #19003 is a reply to message #19002] Mon, 25 February 2002 08:40 Go to previous message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
select column_name,table_name from dba_tab_columns
where column_name='ENTER_COLUMN_NAME'

Report message to a moderator

Previous Topic: EXCEPTIONS AND LOOPS??
Next Topic: Initial Login
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 25 05:37:40 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.