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
- 11872 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
Highlight all the advantages that are attached to a package.
How to get the ddl of a table in db2?
What is null in db2?
How do you find the maximum value in a column in db2?
What is alias in db2?
Is db2 a programming language?
Explain about open switch business continuity software?
How to find primary key of a table in db2?
is it compulsory commitment control in journal?
What is dbrm? When it will be created?
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
Can we insert update delete in view?
What is the maximum size of varchar data type in db2?
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
What is the use of with ur in db2?
