db2查看表索引的命令,db2如何查看索引是否生效

db2查看表索引的命令,db2如何查看索引是否生效

"IDX_T1_02" ON "DB2INST1"."T1" ("ID" ASC, "NAME" ASC) COMPRESS NO ALLOW REVERSE SCANS; --这里显示了索引的名称和索引对应的列COMMIT WORK; CONNEdrwxr-xr-x. 6 bin bin 4096 Aug 14 2014 db2 -r-xr-xr-x. 1 bin bin 5349 Aug 14 2014 db2ckupgrade -r-xr-xr-x. 1 bin bin 5302 Aug 14 2014 db2_deinstall -r-xr-xr-x. 1 bin bi

一、常用命令1. 建立数据库DB2 _GCB CREATE DATABASE DB2 _GCB ON G: ALIAS DB2 _GCB USING CODESET GBK TERRITORY CN COLLATE USING SYSTEM DFT_EXTENT_SZ 32远程连接db2 , catalog 远端DB2 数据库，命令如下：db2 catalog db db_name [as alias_name] at node node_name db2 uncatalog db db_name (取消数据库的编目

?＾? 1、建立表索引create index 索引名on 表名(列名，列名); 2、删除表索引drop index 索引名on 表名；3、查看表索引select * from sysibm.sysindexes where tbDB2查询主键、索引、表约束小熊来了1万+ 查询主键：SELECT K.COLNAME AS 主键名FROM SYSCAT.KEYCOLUES K WHERE TABSCHEMA='SCHEMA' AND TABNAME='TABNAME'; 查询索引SELECT I.IN

(-__-)b db2 查索引db2=>describetablesysibm.sysindexes

（°ο°） selectNAME,CREATOR,COLNAMES,UNIQUERULE,COLCOUNT,NLEVELSfromsysibm.sysindexeswhereTBNAME='TSI_ECUST_SVC'

˙﹏˙ 列类型类型

∪▽∪ 一、常用命令1、建立数据库DB2_GCB CREATE DATABASE DB2_GCB ON G: ALIAS DB2_GCB USING CODESET GBK TERRITORY CN COLLATE USING SYSTEM DFT_EXTENT_SZ 322、连接数据库c

--查看表的索引是哪一类select A.TABNAME, B.COLNAME from syscat.tabconst A ,SYSCAT.KEYCOLUSE B WHERE A.CONSTNAME = B.CONSTNAME AND A.TYPE='P' and A.tabname ='IFS_LKEYCOLUES K WHERE TABSCHEMA='SCHEMA' AND TABNAME='TABNAME'; # 查询索引SELECT I.INDNAME AS 索引名，I.COLNAMES AS 索引字段FROM SYSCAT.INDEXS I WHERE