从视图看
第二种方式 db2 describe查看
第三种方式
使用db2look查看
-
[db2inst1@kvm101 ~]$ db2 "select char(INDSCHEMA,20) SCHEMA,char(INDNAME,20) IDXNAME,char(OWNER,10) OWNER,char(TABSCHEMA,10) TABSCHEMA ,char(TABNAME,20) TABNAME,INDEXTYPE from syscat.indexes where tabname='T1'"
-
-
SCHEMA IDXNAME OWNER TABSCHEMA TABNAME INDEXTYPE
-
-------------------- -------------------- ---------- -----------------
-
DB2INST1 IDX_T1_01 DB2INST1 DB2INST1 T1 REG
-
DB2INST1 IDX_T1_02 DB2INST1 DB2INST1 T1 REG
-
- 2 record(s) selected.
-
[db2inst1@kvm101 ~]$ db2 "select char(TABNAME,20) TABNAME,char(TABSCHEMA,10) TABSCHEMA,char(INDNAME,20) INDNAME,char(OWNER,10) OWNER,INDEXTYPE,char(COLNAMES,50) COLNAMES from syscat.indexes where tabname='T1'"
-
-
TABNAME TABSCHEMA INDNAME OWNER INDEXTYPE COLNAMES
-
------------ ---------- --------------- ---------- --------- --------
-
T1 DB2INST1 IDX_T1_01 DB2INST1 REG +ID
-
T1 DB2INST1 IDX_T1_02 DB2INST1 REG +ID+NAME
-
- 2 record(s) selected.
-
[db2inst3@kvm101 ~]$ db2 "select char(INDSCHEMA,20) SCHEMA,char(INDNAME,20) IDXNAME,char(OWNER,10) OWNER,char(TABSCHEMA,10) TABSCHEMA ,char(TABNAME,20) TABNAME from syscat.indexes where INDSCHEMA='DB2CAE2'"
-
-
SCHEMA IDXNAME OWNER TABSCHEMA TABNAME
-
-------------------- -------------------- ---------- ----------
-
DB2CAE2 T1 DB2CAE2 DB2CAE2 T1
-
DB2CAE2 T0 DB2CAE2 DB2CAE2 T0
-
DB2CAE2 T2 DB2CAE2 DB2CAE2 T2
-
DB2CAE2 T3 DB2CAE2 DB2CAE2 T3
-
DB2CAE2 T4 DB2CAE2 DB2CAE2 T4
-
DB2CAE2 T5 DB2CAE2 DB2CAE2 T5
-
DB2CAE2 IXCDT1 DB2CP2CP DB2CAE2 CDT1
-
DB2CAE2 IXCDT2 DB2CP2CP DB2CAE2 CDT2
-
DB2CAE2 IXCDT3 DB2CP2CP DB2CAE2 CDT3
-
DB2CAE2 IXCDT4 DB2CP2CP DB2CAE2 CDT4
-
DB2CAE2 IXCDT5 DB2CP2CP DB2CAE2 CDT5
-
DB2CAE2 IXCDT0 DB2CAE2 DB2CAE2 CDT0
-
DB2CAE2 TEST01 DB2CAE2 DB2CAE2 TEST01
-
DB2CAE2 IXCDTEST01 DB2CP2CP DB2CAE2 CDTEST01
-
- 14 record(s) selected.
-
[db2inst1@kvm101 ~]$ db2 describe indexes for table db2inst1.t1
-
-
Index Index Unique Number of Index Index
-
schema name rule columns type partitioning
-
------------------------------- ------------------- -------------- --
-
DB2INST1 IDX_T1_01 D 1 RELATIONAL DATA -
-
DB2INST1 IDX_T1_02 D 2 RELATIONAL DATA -
-
- 2 record(s) selected.
使用db2look查看
-
[db2inst1@kvm101 ~]$ db2look -d asp -z db2inst1 -t "T1" -a -e -c
-
-- Generate statistics for all creators
-
-- Schema name is ignored
-
-- The db2look utility will consider only the specified tables
-
-- Creating DDL for table(s)
-
-- This CLP file was created using DB2LOOK Version "9.7"
-
-- Timestamp: Mon 29 Feb 2016 04:37:54 PM CST
-
-- Database Name: ASP
-
-- Database Manager Version: DB2/LINUXX8664 Version 9.7.2
-
-- Database Codepage: 1208
-
-- Database Collating Sequence is: IDENTITY
-
-
-- Binding package automatically ...
-
-- Bind is successful
-
-- Binding package automatically ...
-
-- Bind is successful
-
-
CONNECT TO ASP;
-
-
------------------------------------------------
-
-- DDL Statements for table "DB2INST1"."T1"
-
------------------------------------------------
-
CREATE TABLE "DB2INST1"."T1" (
-
"ID" INTEGER ,
-
"NAME" CHAR(50) )
-
IN "USERSPACE1" ;
-
-
-- DDL Statements for indexes on Table "DB2INST1"."T1"
-
CREATE INDEX "DB2INST1"."IDX_T1_01" ON "DB2INST1"."T1"
-
("ID" ASC)
-
COMPRESS NO ALLOW REVERSE SCANS;
-
-- DDL Statements for indexes on Table "DB2INST1"."T1"
-
CREATE INDEX "DB2INST1"."IDX_T1_02" ON "DB2INST1"."T1"
-
("ID" ASC,
-
"NAME" ASC)
-
COMPRESS NO ALLOW REVERSE SCANS;
-
-
--这里显示了索引的名称和索引对应的列
-
COMMIT WORK;
-
CONNECT RESET;
-
- TERMINATE
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/29023300/viewspace-2120905/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
oracle rba一些小知识
请登录后发表评论
登录
全部评论
