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
- 12039 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 connect my db2 database to ibm?
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
What is difference between isnull and coalesce?
How does a cursor work?
How to restart a DB2 program?
How do I delete a column in db2?
What is null in db2?
What is alias in db2?
List down the data types in the db2 database.
Can you use max on a char column?
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
How to find the number of rows in a db2 table?
What is multi row fetch in db2?
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
Explain the contents that are a part of dclgen.
