I tried both single and double quotes around the word FIRST and
neither worked. I ended up deleting the table and re-creating it.
What a pain!

In addition to the word FIRST it looks like the word TYPE is not
allowed as a valid column name. Does anybody have a global list of
invalid Firebird column names?

--- In ib-support@y..., "Mark Shapiro" <shapirom@s...> wrote:
> Try putting quotes around FIRST - that will force Firebird to look
at it as
> a column name rather than a reserved word.
>
>
> -----Original Message-----
> I recently uninstalled Interbase server and installed Firebird
> server. A database created in Interbase works fine in Firebird
> except for a column called FIRST in one of the tables. I am not even
> able to execute an ALTER TABLE DROP FIRST statement in SQL. Is the
> word FIRST a reserved word in Firebird?