RDB$INDEX_SEGMENTS

 

RDB$INDEX_SEGMENTS specifies the columns that comprise an index for a table. Modifying these rows corrupts rather than changes an index unless the RDB$INDICES row is deleted and re-created in the same transaction.

 

Column name
 Datatype
 Length
 Description
 
RDB$INDEX_NAME
 CHAR
  31 
 The index associated with this index segment; if the value of this column changes, the RDB$INDEX_NAME column in RDB$INDICES must also be changed
 
RDB$FIELD_NAME
 CHAR
  31 
 The index segment being defined; the value of this column must match the value of the RDB$FIELD_NAME column in RDB$RELATION_FIELDS
 
RDB$FIELD_POSITION
 SMALLINT
  
 Position of the index segment being defined; corresponds to the sort order of the index