At 08:15 PM 24/10/2003 +0000, you wrote:

>I am using IBConsole to maintain my firebird database and when I
>choose to check the indexes it gives this error.
>
>Dynamic SQL Error
>SQL error code = -204
>Ambiguous field name between table RDB$INDICES and table
>RDB$INDEX_SEGMENTS
>RDB$INDEX_NAME
>
>Thanks for the help in advance,

The solution is not to rely on the system queries in IBConsole. They *are*
ambiguous and therefore incompatible with Firebird, which won't accept
ambiguous queries.

There are plenty of other tools that *are* Firebird-compatible.

Helen