Description of columns in a DB2 table

sql db2

deepu · Feb 24, 2009 · Viewed 92.8k times · Source

How can we know the description of every column in a table(DB2) through SQL?

My data base is DB2.

Answer

select 
  tabname,
  colname,
  typename,
  length,
  scale,
  default,
  nulls,
  identity,
  generated,
  remarks,
  keyseq 
from 
  syscat.columns