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
- 11650 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?
Is ibm db2 open source?
Define check constraint.
Give the name of some fields form sqlca.
What is syscat in db2?
Why do we need reorg in db2?
What is runstats utility in db2?
What is cobol db2?
What kind of database is db2?
How to check table size in db2 sap?
How would you find out the total number of rows in a db2 table?
What is a trigger in the db2 database?
What is host variable in db2 cobol?
What is null indicator in cobol db2?
What is iseries database?
