Hello!
 
Earlier we can get index SortOrder
----------
SELECT 
  null AS TABLE_CATALOG, 
  null AS TABLE_SCHEMA, 
  idx.rdb$relation_name AS TABLE_NAME, 
  idx.rdb$index_name AS INDEX_NAME, 
  idx.rdb$index_type AS INDEX_TYPE,       /// <- this filed
  seg.rdb$field_name AS COLUMN_NAME, 
  seg.rdb$field_position AS ORDINAL_POSITION, 
  idx.rdb$index_inactive AS IS_INACTIVE, 
  idx.rdb$system_flag AS IS_SYSTEM_INDEX, 
  idx.rdb$unique_flag AS IS_UNIQUE, 
  idx.rdb$statistics AS INDEX_STATISTICS, 
  idx.rdb$description AS DESCRIPTION 
FROM 
  rdb$indices idx 
  left join rdb$index_segments seg ON idx.rdb$index_name = seg.rdb$index_name
----------
now this field removed.

Reply via email to