Change NOT NULL to NULL?

Hi all,
How I change collunm that is NOT NULL to be NULL?
ThanksRetf wrote:
> Hi all,
> How I change collunm that is NOT NULL to be NULL?
> Thanks
ALTER TABLE. You need to specify the datatype as well. Example:
ALTER TABLE tbl ALTER COLUMN x INT NULL ;
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--|||You can do something like this
Use ALTER TableName ALTER COLUMN ColumnName DataType (NULL/NOT NULL)
See example below
CREATE TABLE TESTNULL (
ID INT NOT NULL,
SOMEDATE DATETIME)
INSERT INTO TESTNULL
VALUES (1,
GETDATE())
INSERT INTO TESTNULL
VALUES (NULL,
GETDATE()) --ERROR
ALTER TABLE TESTNULL ALTER COLUMN ID INT NULL
INSERT INTO TESTNULL
VALUES (NULL,
GETDATE())
SELECT *
FROM TESTNULL
DROP TABLE TESTNULL
Denis the SQL Menace
http://sqlservercode.blogspot.com/|||Try using "alter table ... alter column ...".
Example:
use northwind
go
create table t1(c1 int not null default(0))
go
insert into t1 default values
go
select * from t1
go
alter table t1
alter column c1 int null
go
insert into t1 default values
go
select * from t1
go
drop table t1
go
AMB
"Retf" wrote:

> Hi all,
> How I change collunm that is NOT NULL to be NULL?
> Thanks
>
>