How to view DB2 Table structure

Question

How to view the table structure in DB2 database

Please help me

Thanks! in Advance

Regards Ambut Bhath

Answer 1

to get all tables: (You may want to restrict schema to your schema)

select * from syscat.tables

to get all columns: (where tabname = your_tabname)

select * from syscat.columns

Answer 2

Generally it's easiest to use DESCRIBE.

DESCRIBE TABLE MYSCHEMA.TABLE

or

DESCRIBE INDEXES FOR MYSCHEMA.TABLE SHOW DETAIL

etc.

See the documentation: DESCRIBE command

Answer 3

I got the answer from the sysibm.syscolumns

ie.,

Select distinct(name), ColType, Length from Sysibm.syscolumns where tbname = 'employee'

Thanks!

Answer 4

1. Select the Browsers window
2. Extract(expand) it.
3. Select and extract(expand) the table list.
4. Select the required table and extract(expand) it.
5. On double click the code option it opens the table structure.