How to find schema of a table in db2?



How to find schema of a table in db2?..

Answer / Arvind Kumar Sinha

To find the schema of a table in DB2, you can use the DESCRIBE TABLE command. Here is an example: `DESCRIBE TABLE your_table_name;`

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More DB2 Interview Questions

What is the difference between primary key & unique index ?

6 Answers   Patni, Temenos,


What is schema in db2?

1 Answers  


What is a storage group (stogroup)?

1 Answers  


What is the maximum No of rows per page?

1 Answers   IBM,


how 2 resolve the -311 sqlcode

1 Answers  


What are the three DB2 date and time data types and their associated functions?

1 Answers  


Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?

3 Answers  


What is a buffer in memory?

1 Answers  


The only place of VSAM KSDS in DB2 is?

2 Answers   IBM,


What is package in cobol db2?

1 Answers  


Is there any advantage to denormalizing DB2 tables?

1 Answers  


Which one allows duplicate values Union or Union All ?

3 Answers  


Categories