Subject RE: [firebird-support] Querying field names of a relation
Author Thomas Steinmaurer
Hi Christian,

> 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.

Perhaps case-sensitive table names?

Thomas Steinmaurer
LogManager Serie - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database and MS SQL Server
Upscene Productions