Subject Re: [firebird-support] Distinguishing user-defined indexes
Author Ann W. Harrison
Nando Dessena wrote:
>
> for some reason I need to get a list of user-defined indexes
> for a certain table. By "user-defined indexes" I mean everything that
> originated from a CREATE INDEX DDL statement.

All the system created indexes are listed in RDB$RELATION_CONSTRAINTS, I
think. So a NOT EXISTS on that table should work.

Regards,


Ann