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

Which isolation level provides highest data integrity?

675


Why do we bind in db2?

736


Which command is used to remove all rows from a table?

649


Which component is responsible for db2 startup and shutdown?

710


How is a typical db2 batch pgm executed?

720






Is db2 a database?

652


Mention the way of highlighting as well as putting a cursor to use in a cobol program.

716


What is load replace in db2?

639


What is the clustering index in the db2 database?

650


What is lock escalation in db2?

668


How is deadlock resolved?

740


Mention the definition of cobol in varchar field.

776


What is cursor in dbms?

699


How do I connect my db2 database to ibm?

671


What is a system catalog table in db2?

680