付録B.20 ディクショナリ表（実表）のB-treeインデクス
ディクショナリ表（実表）には，次の表に示すB-treeインデクスが定義されています。
表B‒21 ディクショナリ表（実表）のB-treeインデクスの一覧
|
項番
|
ディクショナリ表（実表）
|
インデクス構成列
|
B-treeインデクス名
|
|
1
|
SQL_TABLES
|
TABLE_SCHEMA
|
SQLINDEXM01
|
|
2
|
TABLE_NAME
|
|
3
|
TABLE_ID
|
SQLINDEXS01
|
|
4
|
SQL_COLUMNS
|
TABLE_SCHEMA
|
SQLINDEXM02
|
|
5
|
TABLE_NAME
|
|
6
|
COLUMN_NAME
|
|
7
|
TABLE_ID
|
SQLINDEXS02
|
|
8
|
SQL_DIV_TABLE
|
TABLE_SCHEMA
|
SQLINDEXM05
|
|
9
|
TABLE_NAME
|
|
10
|
DBAREA_ID
|
SQLINDEXS04
|
|
11
|
SQL_INDEXES
|
TABLE_SCHEMA
|
SQLINDEXM03
|
|
12
|
INDEX_NAME
|
|
13
|
TABLE_SCHEMA
|
SQLINDEXM04
|
|
14
|
TABLE_NAME
|
|
15
|
INDEX_ID
|
SQLINDEXS03
|
|
16
|
SQL_DIV_INDEX
|
TABLE_SCHEMA
|
SQLINDEXM06
|
|
17
|
TABLE_NAME
|
|
18
|
TABLE_SCHEMA
|
SQLINDEXM07
|
|
19
|
INDEX_NAME
|
|
20
|
DBAREA_ID
|
SQLINDEXS05
|
|
21
|
SQL_DBAREAS
|
DBAREA_NAME
|
SQLINDEXS06
|
|
22
|
DBAREA_ID
|
SQLINDEXS07
|
|
23
|
N_TABLE
|
SQLINDEXM08
|
|
24
|
DBAREA_ID
|
|
25
|
SQL_SCHEMATA
|
SCHEMA_OWNER
|
SQLINDEXS08
|
|
26
|
SCHEMA_NAME
|
SQLINDEXS09
|
|
27
|
SQL_VIEWS
|
TABLE_SCHEMA
|
SQLINDEXM09
|
|
28
|
TABLE_NAME
|
|
29
|
VIEW_ID
|
SQLINDEXS10
|
|
30
|
SQL_VIEW_TABLE_USAGE
|
VIEW_SCHEMA
|
SQLINDEXM10
|
|
31
|
VIEW_NAME
|
|
32
|
TABLE_SCHEMA
|
SQLINDEXM11
|
|
33
|
TABLE_NAME
|
|
34
|
VIEW_ID
|
SQLINDEXS11
|
|
35
|
SQL_VIEW_OBJECT
|
VIEW_ID
|
SQLINDEXM12
|
|
36
|
OBJECT_NO
|
|
37
|
SQL_DEFINE_SOURCE
|
SOURCE_ID
|
SQLINDEXS12
|
|
38
|
SQL_DEFINE_ENVIRONMENT
|
RESOURCE_TYPE
|
SQLINDEXM13
|
|
39
|
RESOURCE_ID
|
|
40
|
SQL_USERS
|
USER_NAME
|
SQLINDEXS13
|
|
41
|
SQL_TABLE_CONSTRAINTS
|
CONSTRAINT_SCHEMA
|
SQLINDEXM14
|
|
42
|
CONSTRAINT_NAME
|
|
43
|
TABLE_SCHEMA
|
SQLINDEXM15
|
|
44
|
TABLE_NAME
|
|
45
|
SQL_INDEX_COLINF
|
TABLE_SCHEMA
|
SQLINDEXM16
|
|
46
|
INDEX_NAME
|
|
47
|
TABLE_SCHEMA
|
SQLINDEXM17
|
|
48
|
TABLE_NAME
|
|
49
|
SQL_KEY_COLUMN_USAGE
|
CONSTRAINT_SCHEMA
|
SQLINDEXM18
|
|
50
|
CONSTRAINT_NAME
|
|
51
|
COLUMN_NAME
|
|
52
|
TABLE_SCHEMA
|
SQLINDEXM19
|
|
53
|
TABLE_NAME
|
|
54
|
COLUMN_NAME
|
|
55
|
SQL_REFERENTIAL_CONSTRAINTS
|
CONSTRAINT_SCHEMA
|
SQLINDEXM20
|
|
56
|
CONSTRAINT_NAME
|
|
57
|
TABLE_SCHEMA
|
SQLINDEXM21
|
|
58
|
TABLE_NAME
|
|
59
|
PRIMARY_CONSTRAINT_SCHEMA
|
SQLINDEXM22
|
|
60
|
PRIMARY_CONSTRAINT_NAME
|
|
61
|
REFERENCED_TABLE_SCHEMA
|
SQLINDEXM23
|
|
62
|
REFERENCED_TABLE_NAME
|
|
63
|
SQL_TABLE_PRIVILEGES
|
TABLE_SCHEMA
|
SQLINDEXM24
|
|
64
|
TABLE_NAME
|
|
65
|
GRANTEE
|
|
66
|
GRANTOR
|
|
67
|
GRANTOR
|
SQLINDEXS14
|
|
68
|
GRANTEE
|
SQLINDEXS15
|
ページの先頭へ
