| Subject | Re: [firebird-support] Distinguishing user-defined indexes | 
|---|---|
| Author | Ann W. Harrison | 
| Post date | 2005-06-15T20:08:08Z | 
Nando Dessena wrote:
think. So a NOT EXISTS on that table should work.
Regards,
Ann
            >All the system created indexes are listed in RDB$RELATION_CONSTRAINTS, I
> 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.
think. So a NOT EXISTS on that table should work.
Regards,
Ann