Hi,

> 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
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com