Hi,
How can we know the description of every column in a table(DB2) through SQL?
My data base is DB2.
Thanks in Advance
Hi,
How can we know the description of every column in a table(DB2) through SQL?
My data base is DB2.
Thanks in Advance
select
tabname,
colname,
typename,
length,
scale,
default,
nulls,
identity,
genereted,
remark,
keyseq
from
syscat.columns
I work on an iSeries DB2 box (v5r4), it is a special flavor of DB2.
If you're on or connecting to an iSeries (AS/400), the link mentioned by Anton is most excellent (sorry, can't vote yet!)
Describe does not work on an iSeries, but will work with DB2 on the other platforms.