How to view DB2 Table structure

Asked 2010-06-04T10:15:28.467

How to view the table structure in DB2 database

db2

Edit Report

1 Answer

Generally it's easiest to use DESCRIBE.

DESCRIBE TABLE MYSCHEMA.TABLE

DESCRIBE INDEXES FOR MYSCHEMA.TABLE SHOW DETAIL

etc.

See the documentation: DESCRIBE command

answered 2010-06-04T16:23:03.227