meta_Indexes
Returns the indices (primary, secondary, hash, join, and so on) defined for the current tables in the repository. Corresponds to the relationships TableHasIndexes, DatabaseHasHashIndexes, and DatabaseHasJoinIndexes.
Column |
Data Type |
Values |
SystemName |
VARCHAR(256) |
|
DatabaseName |
VARCHAR(128) |
|
TableName |
VARCHAR(128) |
|
IndexName |
VARCHAR(128) |
|
IndexLOID |
INTEGER |
|
IndexType |
CHAR(1) |
|
IndexTypeA |
VARCHAR(35) |
|
IsUnique |
VARCHAR(3) |
|
IndexNumber |
SMALLINT |
|