> How can I with one sql obtain all constraints/indexes for all tables in a
> database.
> The result should be: TableName,Index/Constraint Name.

Query the system tables RDB$RELATION_CONSTRAINTS and/or RDB$INDICES.



--
HTH,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2 (NEW!)
Upscene Productions
http://www.upscene.com