How to see the structure of db2 table??

Answer Posted / ram prajapati

select * from SYSIBM.SYCOLUMNS where tbname='tablename';
run this querry... or
go to dclgen .... option m.11.2 in the ispf command prompt n
see the structure directly in any mentioned ps file

Is This Answer Correct ?    11 Yes 20 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the contention situations caused by locks?

592


Which command is used to connect to a database in DB2 ? Give the Syntax.

602


Is schema the same as database?

631


What is precompiler in db2?

587


What is ibm db2 connect?

573






Name the lockable units in DB2?

665


What is dpf in db2?

666


What are packages in db2?

597


What is rct?

751


What is db2 command?

586


List down the types of triggers in the db2 database?

592


How to find the maximum value in a column in the db2 database?

611


How do you find the maximum value in a column in db2?

650


What is null indicator in db2?

604


What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?

713