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
- 12053 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / ratheesh nellikkal
select name ,tbname ,typeschema,source_tabname from
sysibm.syscolumns where name='coloumn name'
This statement will work.
You can try this command also.
select tabname,colname
from syscat.columns
where COLNAME='ID'
and tabschema='MYSCHEMA'
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is node in db2?
What is scrollable cursor in db2?
What kind of database is db2?
What are the full forms of spufi and dclgen and why are they used?
How and when does the db2 enforces the unique key?
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
What is sqlca’s maximum length?
What is database alias db2?
Which isolation level provides maximum concurrency?
How do you simulate the explain of an embedded sql statement in spufi/qmf?
How to find the maximum value in a column in the db2 database?
What is the maximum No of rows per page?
What is rebind in db2?
What is bind and rebind in db2?
what is diffrence b/w file-aid tool and file-aid utility???
