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...

How to see the structure of db2 table??

Answer Posted / kc

SELECT colName,TypeName FROM SYSCAT.COLUMNS WHERE TABSCHEMA = <database> AND TABNAME =<tablename>

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is performance tuning db2?

1018


Which is faster delete or truncate?

1079


How to execute stored procedures?

1074


What is load replace in db2?

942


Discuss about db2 bind?

1056


What do you mean by rollback?

944


Can there be more than one cursor open for any program?

1133


What is null indicator in db2?

1057


How will you return the number of records in table?

889


What is image copy in db2?

957


Give the name of some fields form sqlca.

1034


Where do you specify them?

1187


What is a db2 cursor?

1012


How is a typical db2 batch pgm executed?

1122


What are the various isolation levels possible?

1057