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
- 9737 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 you simulate the explain of an embedded sql statement in spufi/qmf?
What is a db2 cursor?
What is the difference between bind and rebind in db2?
What are the benefits of using the db2 database?
What is the max length of sqlca?
Mention the different locking levels that are available in db2.
What is copy pending and check pending in db2?
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
How will you return the number of records in table?
What is bufferpool in db2?
What is the maximum length of sqlca?
Is schema the same as database?
How to find primary key of a table in db2?
Is db2 a mainframe?
Explain about rct in db2?
