> In firebird 1.0, can I alter the type of a column without having to
> drop the unique constraint?
>
> I have to change the column from a varchar(9) to varchar(50) so there
> shouldn't be any issue with data conversion or truncation. Right now I
> have to drop the constraint and readd it. I am just curious if there
> is an "ignore constraints" mode of operation?

No, there isn't. You have to drop the constraints first.

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