How to add a null value to an existing SQL Server column?

Question

I set up a table in SQL Server 2008 Express and forgot to add a non-zero constraint to my unique recordid column. I tried to add it later, with this statement:

 alter table movie_archive alter column RecordID Not null; 

but he gives me an error message saying a syntax error of "no." What am I doing wrong?

Answer 1

specify the data type of the column

 ALTER TABLE [Table] ALTER COLUMN [Column] INTEGER NOT NULL; alter table movie_archive alter column RecordID INTEGER Not null;