In language reference it is documented: Table RDB$INDICES Column RDB$INDEX_TYPE: Distinguishes between an expression index (1) and a regular index (0 or null). Not used in databases created before Firebird 2.0; hence, regular indexes in upgraded databases are more more likely to store null in this column
But, according to this discussion: https://github.com/FirebirdSQL/firebird/issues/4085 RDB$INDEX_TYPE identifies a descending or ascending index. It appears the doc is wrong Regards, Ariel
Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
