Hi,

> I am trying to query the field names of a relation with
> the following statement:
>
> SELECT Rdb$Field_Name
> FROM Rdb$Relation_Fields
> WHERE Rdb$Relation_Name = 'MyTable'
>
> For some tables, this works, but for some other tables,
> the query returns no rows.

Make sure that "MyTable" is in the right case.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com