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
- 11838 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 the use of commit in db2?
Which is faster delete or truncate?
What is lock escalation in db2?
What are the benefits of using the db2 database?
What is db2 look?
What is schema in db2?
What is database manager in db2?
What is db2? Explain.
What is the use of with ur in db2?
What is dbrm library?
How would you find out the total number of rows in a db2 table?
What are the 2 sqlcodes that are returned?
What is runstats and reorg in db2?
what is db2 restart?
What type of database is db2?
