Progress
SQL-92
Guide and Reference


SYSINDEXES Core SystemTable

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.

Table B–4: 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


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095