you also can try this:
alter table [tablename] modify(column_name data_type NULL)

-----Original Message-----
From: yuenkit [mailto:janet_smith2000@y...]
Sent: Tuesday, March 20, 2001 16:25 PM
To: sql language
Subject: [sql_language] Re: making a column accept Null values


u mean u wanna convert the property of the column or just create a column
with null value?

if u just wanna add column with null value
try this,

strSQL = "ALTER TABLE [table_name] ADD [column_name] INT NULL;"

> Hi,
>
> I want to write a sql statement to make a column in table to accept Null
> values. Currently the column does not take Null values and now I want to
> change it to accept Null values.
>
> Could you please help?
>
> Thank you