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
- 9736 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / apoorv sharma
Learn SQL Trace for that... Tcode is ST05.
After this u will come to know which table contain those fields
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is a cursor in programming?
What is the maximum No of rows per page?
What are the contents of dclgen?
Who uses db2?
How to retrieve rows from a db2 table in embedded sql?
If I have a view which is a join of two or more tables, can this view be updateable?
Explain in detail about buffer manager and its functionalities?
How and when does the db2 enforces the unique key?
what is db2 restart?
What is scrollable cursor in db2?
What are the two types of logging in the db2 database? Explain them.
Before you give the explain statement, what are the prerogatives?
what is the role of the cursor in db2?
What is dbrm? What it contains?
What is copy pending status in db2?
