>> select
>> *
>> from
>> rdb$indices i
>> where
>> (i.rdb$system_flag = 0 or i.rdb$system_flag is null)
>> and not exists (select 1 from rdb$relation_constraints r where
>> r.rdb$index_name = i.rdb$index_name)

M> Exactly. This filters indices not created by constraints. Easy :-)

...once you know it. :-)
Didn't bother to have a look at RDB$RELATION_CONSTRAINTS to see if the
index name was recorded there... Thanks a lot Thomas (and Martijn).

Ciao
--
Nando Dessena
http://www.flamerobin.org
======================================================
I support Firebird, I am a Firebird Foundation member!
Join today at http://www.firebirdsql.org/ff/foundation
======================================================