How to see the structure of db2 table??

Answer Posted / prem

Use the Describe command

eg: Describe table <tablename>

Is This Answer Correct ?    38 Yes 47 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a Foreign Key?

658


Is db2 a mainframe database?

567


What are host variables in db2?

626


Mention the various locks that are available in db2.

616


What is the maximum size of a char data type in db2?

588






What are the benefits of using the db2 database?

662


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

1041


How to connect to db2 database from windows command line?

562


What is a trigger in the db2 database?

596


What is the use of commit in db2?

634


What is a db2 package?

599


What is the use of predicate?

586


what is db2 restart?

1693


How do I optimize a query in db2?

624


What is phantom read in db2?

640