AX1023
Axiom.ColumnSequences
The Axiom.ColumnSequences system table contains information about the defined column sequences in your system.
This table contains information about the sequence record itself, not about the individual columns in the sequence. For information about the individual columns, query the Axiom.ColumnSequenceItems table.
Available columns
The following columns can be queried:
| Column | Description |
|---|---|
|
TableID |
The database ID of the table that the sequence belongs to. |
|
TableName |
The name of the table that the sequence belongs to. |
|
SequenceID |
The database ID of the sequence. |
|
SequenceName |
The name of the sequence. |
|
RateSequenceID |
The database ID of the associated data conversion sequence, if applicable. Returns zero if the sequence is not mapped to a data conversion sequence. |
|
StartPeriod |
The starting period for the sequence. |
|
CreatedByID |
The database ID of the user who created the sequence. |
|
CreatedDTM |
The date/time the sequence was created. |
|
ModifiedByID |
The database ID of the user who last modified the sequence. |
|
ModifiedDTM |
The date/time the sequence was last modified. |
NOTE: The database IDs assigned to sequences are not permanent. If you need to identify a particular sequence you should use the combination of SequenceName/TableName.
Save Type 4 support
Axiom.ColumnSequences can be modified using Save Type 4. See Managing column sequences using Save Type 4.
