DB2 数据库表 表结构 查询语句

①DB2取得所有非系统表：

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;       

②DB2取得表结构相关信息

SELECT RTRIM(C.TABSCHEMA) AS CONTCONTNAME,
       C.TABNAME AS CONTNAME,
       C.COLNAME AS NAME,
       C.REMARKS AS COMMENT,
       TC.TYPE AS ISPRIM,
       SECLABELNAME AS SECLABELNAME,
       RTRIM(C.TYPESCHEMA) AS SOURCE_SCHEMA,
       C.TYPENAME AS SOURCE_NAME,
       C.LENGTH AS LENGTH,
       C.SCALE AS SCALE,
       C.CODEPAGE AS CODEPAGE,
       C.NULLS AS NULLS,
       C.COMPRESS AS COMPRESS,
       C.DEFAULT AS DEFAULT,
       C.GENERATED AS GENERATED,