Release 10.1A: OpenEdge Data Management:
SQL Reference

> ## 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.

> Table 7 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

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