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
- 9738 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
Describe major components of db2?
What is the physical storage length of the data types date, time, and timestamp?
What's The Percentage Free Space ?
Comment whether the cursor is closed during commit or not.
What is a db2 cursor?
How to compare data between two tables in db2?
What is the syntax for seeing the columns and data types of a table in the db2 database?
what is utility for parm lib
What is image copy in db2?
Explain what are the various isolation levels possible?
Mention the definition of cobol in varchar field.
What is with ur in db2?
Give the name of some fields form sqlca.
What is a storage group (stogroup)?
What is query_cache_limit?
