Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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..

Answer Posted / dalwinder singh--intense tech

db2 "select name ,tbname ,typeschema,source_tabname from
sysibm.syscolumns where name='coloumn name'"

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a cursor in programming?

1063


What is the usage of open cursor command?

1100


How is the value function used?

1152


Is ibm db2 open source?

1070


What are bind parameters in db2?

1044


What is db2 plan table?

1044


How to retrieve rows from a db2 table in embedded sql?

1385


What is declare cursor?

1113


Before you give the explain statement, what are the prerogatives?

1028


Explain package in db2 and its advantages?

1208


How to find the number of rows in db2 tables?

1065


How do I delete a table in db2?

1062


How can you classify the locks in db2?

1088


Describe major components of db2?

1089


File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?

2933