How to view db2 table structure?



How to view db2 table structure?..

Answer / Madhulika Kumari

You can use the DESCRIBE or DESC command in DB2 to view the structure of a table, including column names, data types, and lengths. For example: `DESCRIBE your_table_name`.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More DB2 Interview Questions

What is db2 catalog database?

1 Answers  


Mention data types used in db2 ?

1 Answers  


What is an instance in db2?

1 Answers  


Mention and explain the contention situations caused by locks?

1 Answers  


What statistic will tell the DBA how must space can be reclaimed from dropped table spaces on the next reorg run?

1 Answers  


What is cursor?

2 Answers  


Is schema the same as database?

1 Answers  


how to resolve -811 error. give clear explination

4 Answers   IBM,


how to execute qcmdexc in rpgle?plz write code also?

1 Answers   IBM,


What is lock contention?

1 Answers  


Explain about mirror activator disk mirroring?

1 Answers  


What happens to the PLAN if index used by it is dropped?

1 Answers  


Categories