|Subject||Re: [firebird-support] Dropping a column|
> Well, I do not think it is possible to change to dialect 3 with columnI think you can. The best solution - which I totally forgot about - was
> namens like that. Or perhaps I am mistaken?
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! IWell, that's good to hear :-)
> 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!
Guess I need to eat my own dogfood more often ;-)
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Database development questions? Check the forum!