Did you read Louis answer last time you asked?

http://groups.yahoo.com/group/firebird-support/message/63329

Set

--- In firebird-support@yahoogroups.com, "Ruaan Barnard" wrote:
> Let's try again. This is a repost.
>
> Hi
>
> How can I with one sql obtain all constraints/indexes for all tables
in
> a database.
> The result should be: TableName,Index/Constraint Name.
>
> TIA
>
> Ruaan