Use the Describe command eg: Describe table <tablename>

How to see the structure of db2 table??

Question Posted / prem

Answer Posted / prem

Use the Describe command

eg: Describe table <tablename>

Is This Answer Correct ?

38 Yes

47 No

Please Help Members By Posting Answers For Below Questions

What happens in bind step in a db2 program?

964

What are types of indexes?

1063

Who uses db2?

1032

What r the comman abends in db2, jcl and cobol???????

2250

What is meant by dclgen?

1099

How do I copy a table in db2?

994

Which component is used to execute the sql statements?

1092

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

1145

What is a cursor in programming?

1060

What is the physical storage length of the data types: date, time, timestamp in the db2 database?

1154

How to fetch the last row from the table in SQL (db2)?

1649

Is db2 a mainframe database?

996

What are the various data types available in db2?

1088

What is a storage group (stogroup)?

1241

What are iseries servers?

1071