Subject Re: [firebird-support] Dropping a column
Author Martijn Tonies

> I have restored a Database on FB 1.5.2 which was originally on IB 6.
> Working with the data, everyting works ok. However, the database is
> still dialect 1. I want to convert to dialect 3 and in order to do so,
> I have to change some of the column names.
> My problem is with a column named TIMESTAMP. FB refuses to drop that
> column saying "Token unknown"

Alter table <mytable> DROP COLUMN "TIMESTAMP"

With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Upscene Productions
Database development questions? Check the forum!