Reference Manual
CHAPTER 15. System Tables
Column name |
Column type |
Column constraint |
Table constraints |
|---|---|---|---|
table_id |
SMALLINT |
NOT NULL |
Primary key, Unique index |
index_id |
SMALLINT |
NOT NULL |
Primary key |
root |
INTEGER |
NOT NULL |
|
file_id |
SMALLINT |
NOT NULL |
|
"unique" |
CHAR(1) |
NOT NULL |
|
creator |
SMALLINT |
NOT NULL |
Foreign key references SYS.SYSUSERPERM. user_id |
index_name |
CHAR(128) |
NOT NULL |
Unique index |
remarks |
LONG, VARCHAR |
Each index in the database is described by one row in SYSINDEX. Each column in the index is described by one row in SYSIXCOL.
table_id Uniquely identifies the table to which this index applies.
index_id Each index for one particular table is assigned a unique index number.
root Indexes are stored in the database as B-trees. The root identifies the location of the root of the B-tree in the database file.
file_id The index is completely contained in the file with this file_id (see SYSFILE).
unique Indicate whether the index is a unique index ("Y"), a non-unique index ("N"), or a unique constraint ("U"). A unique index prevents two rows in the indexed table from having the same values in the index columns.
creator The user number of the creator of the index. This user is always the same as the creator of the table identified by table_id.
index_name The name of the index. A user ID cannot have two indexes with the same name in tables that it owns..
remarks A comment string.