Re: NOT NULL -> allow NULL

From: Johannes <gedichte@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? I don't know, but have you tried: ALTER TABLE table_name MODIFY (column_name datatype); ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com