ASA SQL Reference
System Tables
| Column name | Column type | Column constraint | Table constraints |
|---|---|---|---|
| table_id | UNSIGNED INT | NOT NULL | Primary key. Foreign key references SYSCOLUMN. Foreign key references SYSINDEX. |
| index_id | UNSIGNED INT | NOT NULL | Primary key. Foreign key references SYSINDEX |
| sequence | SMALLINT | NOT NULL | Primary key |
| column_id | UNSIGNED INT | NOT NULL | Foreign key references SYSCOLUMN |
| "order" | CHAR(1) | NOT NULL |
Every index has one row in SYSIXCOL for each column in the index.
table_id Identifies the table to which the index applies.
index_id Identifies in which index this column is used. Together, table_id and index_id identify one index described in SYSINDEX.
sequence Each column in an index is assigned a unique number starting at 0. The order of these numbers determines the relative significance of the columns in the index. The most important column has sequence number 0.
column_id The column number identifies which column is indexed. Together, table_id and column_id identify one column in SYSCOLUMN.
order (A/D) Indicate whether this column in the index is kept in ascending or descending order.