How do you drop a column in firebird

firebird, sql

Solution

You must omit the "COLUMN" keyword:

ALTER TABLE student DROP id;

Problem

I'm using firebird and attempting to drop a column but the following SQL does not work: ``` ALTER TABLE student DROP COLUMN id; ```

Original source