Interested to Buy Any Domain ? << Click Here >> for more details...
I have some 3 particular fields ..i want to know which all
tables have those 3 fields. Is there any way to identify..
can we know by quering system tables..
- 5 Answers
- 11873 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / rajnish kumar
SELECT R.TABSCHEMA , R.TABNAME FROM
(select TABSCHEMA,TABNAME,COLNAME from syscat.columns where
COLNAME='ROLL') R
INNER JOIN
(select TABSCHEMA,TABNAME,COLNAME from syscat.columns where
COLNAME='NAME') N
ON R.TABNAME=N.TABNAME AND R.TABSCHEMA= N.TABSCHEMA
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are concurrency issues?
List some fields from sqlca?
Why do we need reorg in db2?
Explain correlated sub-queries.
Is db2 a database?
How do I add a column in db2?
What is null value in db2?
What is the use of runstats in db2?
What is reorg?
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
What is node in db2?
What do you mean by between and in? Is between inclusive of specified range values?
How can you classify the locks in db2?
Why cursor is used in db2?
Can you use max on a char column?
