How to get table's field description for DB2

cy163 · #1 (**permalink**) 04-07-11, 11:19

Hello ALL,

I wonder what command can be used to get the description of fields of a table,i.e., info about data type, length of ALL fields in a table.

Thanks

n_i · #2 (**permalink**) 04-07-11, 11:47

Code:

describe table myschema.mytable

or

Code:

select colname, typename, length, scale from syscat.columns 
where tabschema = 'MYSCHEMA' and tabname = 'MYTABLE'

ARWinner · #3 (**permalink**) 04-07-11, 11:47

You can use either DESCRIBE, db2look, or query the syscat tables.

Andy

Internet Services

Web Development

Digital Marketing

Consumer Tech