Using the INDEXES system table, you can determine the following database information, among other things:
·
All indexes of
the table ROOM and specification of which of the indexes currently has the
status disabled
SELECT indexname,
disabled
FROM DOMAIN.INDEXES
WHERE tablename = 'ROOM'
·
All
UNIQUE indexes (regardless of which of the possible SQL statements was used to
generate these indexes: CREATE INDEX
statement or UNIQUE
definition)
SELECT owner,
tablename, indexname
FROM DOMAIN.INDEXES
WHERE type = 'UNIQUE'
Columns of an index: see INDEXCOLUMNS