NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
I-10
INDEXES Table
INDEXES Table
The INDEXES table is a catalog table that describes primary keys and indexes. The
following table describes the contents of the INDEXES table.
The columns TABLENAME through FILENAME (1 through 12) were created in
version 1. The columns SECURITYVECTOR through OBJECTVERSION (13 through
15) were added in version 300.
Column Name Data Type Description
1 TABLENAME * CHAR(34) Name of indexed table
2 INDEXNAME * CHAR(34) Name of index (name of primary key
index is same as table name)
3 TABLECODE
SMALLINT
UNSIGNED
Code for type of table;
codes 100-999
mean reserved for Tandem use, other
numbers are values of TABLECODE file
attribute
4 COLCOUNT SMALLINT
SIGNED
Number of columns in index (includes keytag
and, if table not unique, includes primary key
columns)
5 CREATETIME LARGEINT
SIGNED
Julian timestamp from index creation
6 KEYTAG SMALLINT
UNSIGNED
Keytag specifier; 0 for primary key index
7 UNIQUEVALUE CHAR(1) Y if index is unique
N if not
8 VALIDDEF CHAR(1)
Y if index definition is valid (catalog tables
and disk label are correct and consistent)
N if not
9 VALIDDATA CHAR(1) Y if index has valid data
N if not
10 INDEXLEVELS SMALLINT
SIGNED
Number of levels of indexing (maintained
by UPDATE STATISTICS)
11 ROWSIZE SMALLINT
SIGNED
Length of packed index record
12 FILENAME CHAR(34) Name of file that contains index
13 SECURITYVECTOR CHAR(4) Guardian security string for the index
14 SECURITYMODE CHAR(1) Type of security in use:
S Safeguard
G Guardian
15 OBJECTVERSION SMALLINT
UNSIGNED
Version number of index
* Indicates primary key