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 an instance database?

1047


What is the maximum No of rows per page?

1063


What is the role of union all and union

1121


what is utility for parm lib

2367


What is dbrm? When it will be created?

1021


List out the three types of page locks that can be held.

1145


Explain dclgen.

1191


What is view db2?

1063


How do you stop a db2 database in linux?

1008


How will you return the number of records in table?

930


What is load utility in db2?

1179


What happens in bind step in a db2 program?

964


What are the contents of a dclmgen?

1120


What is buffer pool and list some of them?

1019


What is temporal table in db2?

1033