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
- 11844 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
Why do chiropractors use drop table?
Where do you specify them?
Explain the function done by data manager?
Explain dclgen.
What is the use of commit in db2?
What is meant by union and union all?
What are host variables in db2?
What action db2 takes when a program aborts in the middle of a transaction?
What do you mean by cursor?
What do you mean by commit and rollback?
What is bind in db2?
What is drop table?
How do I add a column in db2?
What is the meaning concurrency in the db2 database?
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2
