Hi Ruaan

Try

SELECT RDB$INDEX_NAME,
RDB$RELATION_NAME
FROM RDB$INDICES
where rdb$relation_name not starting with 'RDB$'

HTH

Louis

Ps. I suggest you check out system tables. . . . . . . . .



-----Original Message-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Ruaan Barnard
Sent: 12 July 2005 02:58 PM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] How to get constraints/index name for all tables
in database

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


[Non-text portions of this message have been removed]



++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://firebird.sourceforge.net and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Yahoo! Groups Links