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
- 11823 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / srini
select * from sysibm.syscolumns where name = <name you 3
columns here>
The above query to metadata will show you the list of table
names where these 3 columsn present
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
How do I start db2 in windows?
What is the information associated with sysibm.syslinks table?
What is load replace in db2?
How can deadlocks be resolved?
What are db2 tables?
Explain correlated sub-queries.
How do I delete a table in db2?
What is buffer pool?
How do I change the column size in db2?
What is query_cache_limit?
Can there be more than one cursor open for any program?
How to rename a table in DB2 ?
What is the use of value function?
What is nvl in db2?
What is the difference between drop table and delete table?
