Subject | Re: [ib-support] Alter table error |
---|---|
Author | Claudio Valderrama C. |
Post date | 2001-12-18T04:15:27Z |
"Antonio Natividad" <locosoft_lnx@...> wrote in message
news:20011217154622.8354.qmail@......
know what to suggest.
C.
news:20011217154622.8354.qmail@......
>If you are using FB, you need a new version. If you are using IB, I don't
> SQL> create table t(a int, b int not null);
> SQL> alter table t add constraint un_b unique(b);
> SQL> alter table t drop constraint un_b;
> SQL> alter table t drop b;
>
> SQL> alter table t add b int not null;
> SQL> alter table t add constraint un_b unique(b);
>
> The error is in the 5 line (sometimes in the 6)
know what to suggest.
C.