SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
I-10
INDEXES Table
INDEXES Table
The INDEXES table is a catalog table that describes primary keys and indexes.
Table I-1 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.
Table I-1. The INDEXES Table
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 HP 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