首页 > 专利信息

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;

2.2查看指定表表结构

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,

C.TEXT AS TEXT,

C.IDENTITY AS IDENTITY,

吸湿剂

C.LOGGED AS LOGGED,

C.COMPACT AS COMPACT,

肛门塞

C.PARTKEYSEQ AS PARTKEYSEQ,

RTRIM(C.DL_FEATURES) AS DL_FEATURES,

C.INLINE_LENGTH AS INLINELENGTH,

CID.START AS START,

CID.INCREMENT AS INCREMENT,

CID.CACHE AS CACHE,

CID.MINVALUE AS MINVALUE,

CID.MAXVALUE AS MAXVALUE,

CID.CYCLE AS CYCLE,

ORDER AS ORDER

ad2组合FROM SYSCAT.COLUMNS C

LEFT OUTER JOIN SYSCAT.KEYCOLUSE KCU ON KCU.TABSCHEMA = C.TABSCHEMA

AND KCU.TABNAME = C.TABNAME

AND KCU.COLNAME = C.COLNAME

LEFT OUTER JOIN SYSCAT.TABCONST TC ON TC.CONSTNAME = KCU.CONSTNAME

子液位计LEFT OUTER JOIN SYSCAT.COLIDENTATTRIBUTES CID ON CID.COLNAME = C.COLNAME

AND CID.TABNAME = C.TABNAME AND CID.TABSCHEMA = C.TABSCHEMA

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

AND (C.TABNAME = 'TABLE_NAME') ---此处修改表名

AND (RTRIM (C.TABSCHEMA) = 'SCHEME') ---此处修改scheme ORDER BY COLNO FOR FETCH ONLY;

本文发布于:2024-09-20 23:30:03，感谢您对本站的认可！

本文链接：https://www.17tex.com/tex/2/203761.html

上一篇：金陵科技学院-管理会计（双语）管理会计复习提纲

下一篇：和学习率_DL知识拾贝（Pytorch）（五）：如何调整学习率

标签：查看指定电能连接油田表名

留言与评论（共有 0 条评论）