Try OpenEdge Now
skip to main content
SQL Reference
SQL Reference : OpenEdge SQL System Catalog Tables : SYSINDEXES
 

SYSINDEXES

Contains one row for each component of an index in the database. For an index with n components, there will be n rows in this table.
The following table provides details of the SYSINDEXES table.
Table 7. SYSINDEXES core system table
Column name
Column data type
Column size
abbreviate
BIT
1
active
BIT
1
creator
VARCHAR
32
colname
VARCHAR
32
desc
VARCHAR
144
id
INTEGER
4
idxcompress
VARCHAR
1
idxmethod
VARCHAR
2
idxname
VARCHAR
32
idxorder
CHARACTER
1
idxowner
VARCHAR
32
idxsegid
INTEGER
4
idxseq
INTEGER
4
ixcol_user_misc
VARCHAR
20
rssid
INTEGER
4
tbl
VARCHAR
32
tblowner
VARCHAR
32