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
- 12045 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 is bind and rebind in db2?
What is a db2 cursor?
What are the prerogatives?
How to check table size in db2 sap?
What does reorg do in db2?
Explain about cursor stability?
What is commit in db2?
Comment whether the cursor is closed during commit or not.
What are the contents of dclgen?
How to check last update on table in db2?
Is db2 free?
Can we update view in db2?
Highlight all the advantages that are attached to a package.
What is the syntax for FETCH in DB2 ?
What is universal database?
