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
- 11651 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
When the like statement is used?
What is the difference between nvl and coalesce?
Are views updateable?
What is ibm db2 used for?
When reorg is used?
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
Mention the different locking levels that are available in db2.
Highlight all the advantages that are attached to a package.
What is cursor stability in db2?
What are the various isolation levels possible?
What os does db2 run on?
How do you concatenate the firstname and lastname from emp table to give a complete name?
Is db2 a mainframe database?
Discuss about db2 bind?
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2
