READONLY = 1 means that objects can be created, opened but not saved or deleted. Tables are projected to SQL as READONLY.

Sort sequence for the column: "A" for ascending; "D" for descending. InterSystems IRIS only supports "A" sort sequences.

Name of column in the index.

Comma-separated list of data field names stored in this index, which can be retrieved as part of an index lookup without requiring an additional master map lookup. Data field names are returned as delimited strings. Note that this table has one row for each indexed field (COLUMNNAME), but will repeat the list of data fields for each of those.

Table qualifier - always NULL in InterSystems IRIS.

Name of the index.

Name of schema that contains the index. Always the same as the TABLE_SCHEMA.

Status information on this index map, indicating whether it is selectable by the query optimizer or not. Map selectability can be controlled via $SYSTEM.SQL.Util.SetMapSelectablity()

NON_UNIQUE indicates whether or not the index is a unique index. Returns one of the following values:

• 1 - If the index values can be nonunique (not a unique index).
• 0 - if the index values must be unique (a unique index).

Column sequence number in index (starting with 1).

PRIMARY_KEY indicates whether or not the index is a primary key index. Returns one of the following values:

• 1 - If the index values are the primary key values.
• 0 - if the index values are not the primary key values.

Table qualifier - always NULL in InterSystems IRIS.

Name of the table.

Name of schema that contains the table.