> Well, I do not think it is possible to change to dialect 3 with column
> namens like that. Or perhaps I am mistaken?

I think you can. The best solution - which I totally forgot about - was
the one by Helen though. That's exactly what Dialect 2 is for.

> Anyway, I was able to solve my problem using your database workbench! I
> downloaded your trial and with that I could actually change the name of
> the offending column. The syntax used was:
>
> ALTER TABLE <tablename>
> ALTER TIMESTAMP TO CREATETIMESTAMP
>
> After that, dropping that renamed column was no problem!

Well, that's good to hear :-)

Guess I need to eat my own dogfood more often ;-)

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