NOT NULL -> allow NULL

Posted in 2000

Johannes — Wed, 14 Jun 2000 17:12:12 +0200 — source: Informix-list mailing list archive (1991-1998)

I have a column with the parameter NOT NULL. Now I want to allow NULLs. I tried: ALTER TABLE table_name MODIFY (column_name NULL);But I just get a syntax error. I coudn't find anything about this problem. How can I change the column type, to allow nulls? Thanks Johannes

↪ replying to Johannes

Ben Draper — Wed, 14 Jun 2000 11:26:04 -0400 — source: Informix-list mailing list archive (1991-1998)

How about alter table drop constraint? "Johannes" <gedichte@lycosmail.com> wrote in message news:3947A0CC.4F2F6A62@lycosmail.com... > I have a column with the parameter NOT NULL. Now I want to allow NULLs. > I tried: > ALTER TABLE table_name MODIFY (column_name NULL);> But I just get a syntax error. I coudn't find anything about this > problem. > > How can I change the column type, to allow nulls? > > Thanks > Johannes >

↪ replying to Johannes

stumbde — Wed, 14 Jun 2000 14:41:56 -0400 — source: Informix-list mailing list archive (1991-1998)

The Syntax is ALTER TABLE table_name MODIFY (column_name Data_type NULL);Sameer Johannes <gedichte@lycosmail.com> wrote in message news:3947A0CC.4F2F6A62@lycosmail.com... > I have a column with the parameter NOT NULL. Now I want to allow NULLs. > I tried: > ALTER TABLE table_name MODIFY (column_name NULL);> But I just get a syntax error. I coudn't find anything about this > problem. > > How can I change the column type, to allow nulls? > > Thanks > Johannes >