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
- 11690 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 picture clause of null indicator variable?
Is the primary key a clustered index?
How can we retrieve the total number of records in RPG & CLLE?
Explain correlated sub-queries.
Which component is responsible for db2 startup and shutdown?
What is the meaning concurrency in the db2 database?
How do I connect my db2 database to ibm?
What are foreign keys in db2?
What are host variables in db2?
is it compulsory commitment control in journal?
What is coalesce in db2?
What is phantom read in db2?
Who uses db2?
Which command is used to remove all rows from a table?
