Subject Re: [firebird-support] Querying field names of a relation
Author Martijn Tonies

> 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
Upscene Productions