ALTER TABLE to add column with nulls

[jararaca]

How do I use ALTER TABLE to add a column that allows nulls?

Thank you!

 

[SQLDenis]

ALTER TABLE TableName ADD ColumnName DataType NULL


example

CREATE TABLE CategoryList ( 
        Category varchar(50) NOT NULL
       
) 

--here it is
ALTER TABLE CategoryList ADD Column2 int NULL

INSERT INTO CategoryList VALUES ('Test Category',NULL) 

INSERT INTO CategoryList VALUES ('Test Category',123) 


select * from CategoryList

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/