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
- 11679 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 the difference between cursor stability and repeatable read isolation levels?
How and when does the db2 enforces the unique key?
How to rename a table in DB2 ?
What is the difference between plan and package in db2?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
How to check table size in db2 sap?
How can you classify the locks in db2?
Explain about open switch business continuity software?
What is a storage group (stogroup)?
Explain about dbrm.
What do you mean by between and in? Is between inclusive of specified range values?
what is utility for parm lib
Is db2 a database?
What is the use of predicate?
What is rct?
