db2 常量表_DB2查看用户表与指定用户表表结构

1.在dos中查看用户表

1.1查看表

DB2 LIST TABLES FOR USER

1.2 查看表结构

DB2 describe table A

2.在DB2连接工具中(这里以SQLdbx为例子)

2.1查看用户表清单

SELECT RTRIM(TABSCHEMA) AS CONTNAME, --

RTRIM(TABNAME) AS NAME,

RTRIM(TBSPACE) AS TBSPACE,

DEFINER AS DEFINER

FROM SYSCAT.TABLES

WHERE (LEFT (TABSCHEMA,3) <> 'SYS')

AND (TYPE = 'T')

ORDER BY CONTNAME, NAME FOR FETCH ONLY;