IB 6

Interesting:

If I run

select cast (RDB$RELATION_NAME as varchar(32)) AS TABLE_NAME, cast (RDB$INDEX_NAME as varchar(32)) AS INDEX_NAME, RDB$STATISTICS from rdb$indices where 0 = 0 AND RDB$SYSTEM_FLAG = 1 order by RDB$STATISTICS DESC

The result set is all the system tables. Running RDB$SYSTEM_FLAG = 0 returns zilch.

Makes NO sense.

I checked the RDB$SYSTEM_FLAG parameter and it is correct for the two different kinds of tables.