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
- 10659 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / dalwinder singh--intense tech
db2 "select name ,tbname ,typeschema,source_tabname from
sysibm.syscolumns where name='coloumn name'"
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Why do we bind in db2?
How to take backup of table in db2?
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
How does db2 sample database connect?
What is the use of value function?
When do you specify the isolation level?
what is the role of the cursor in db2?
Why do chiropractors use drop table?
What is the physical storage length of timestamp data type?
Mention the various locks that are available in db2.
What is the physical storage length of time data type?
What is release/acquire in bind?
Explain package in db2 and its advantages?
List out the data types available.
What is phantom read in db2?
