Subject | alter column with unique constraint. |
---|---|
Author | josephhirn |
Post date | 2006-02-03T21:46:39Z |
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?
Thanks!
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?
Thanks!