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.

I would be very glad about hints what I am doing wrong.



TIA,
Christian