db2中怎样查询表结构

这样查看表结构：

describe select photo_format from emp_photo

db2 =>describe select photo_format from emp_photo

SQLDA Information

sqldaid : SQLDA sqldabc: 896 sqln: 20 sqld: 1

Column Information

sqltype sqllen sqlname.datasqlname.length

448 VARCHAR 10 PHOTO_FORMAT12

describe select * from emp_photo

db2 =>describe select * from emp_photo

SQLDA Information

sqldaid : SQLDA sqldabc: 896 sqln: 20 sqld: 3

Column Information

sqltype sqllen sqlname.datasqlname.length s

qllonglen sqldatatype_name.datasqldatatype_name.length

452 CHARACTER6 EMPNO 5

0 SYSIBM .CHARACTER 18

448 VARCHAR 10 PHOTO_FORMAT 12

0 SYSIBM .VARCHAR 16

405 BLOB 0 PICTURE 7

102400 SYSIBM .BLOB 13

1、 select * from sysibm.syscolumns where tbname = <table name>

或者

2、describe select * from <table name>

---