Subject Re: [firebird-support] Dropping a column
Author Martijn Tonies
> 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>
> 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
Upscene Productions
Database development questions? Check the forum!