Subject Referencing "active" as a column name
Author ohfrabjousday
I am creating my first Interbase/Firebird project by porting a large
Sybase Adaptive Server Anywhere database. In the process, I discovered
that "active" is an IB keyword. Several of my tables have this as a
column name. So I enclosed the name in double quotes and went forward
with the table creation process.

Now when I try to reference an "active" column in DSQL, I get a "local
column not found error." Here are two examples of SQL statements that

ALTER TABLE ProgCat ALTER "active" TO isactive
ALTER TABLE ProgCat DROP "active"

Any guidance here would be much appreciated.