How to add a not null to an already existing column in SQL Server? [duplicate]

5

This question already has an answer here:

I've setup a table in SQL Server 2008 Express and forgot to add a not null constraint to my unique recordid column. I tried to add it afterward, with this statement:

alter table movie_archive alter column RecordID Not null;

but it gives me an error message, saying there's a syntax error at "not". What am I doing wrong?

kyle5385

출처 sql sql-server alter-table

1 답변

13

specify the datatype of the column

ALTER TABLE [Table] ALTER COLUMN [Column] INTEGER NOT NULL;

alter table movie_archive alter column RecordID INTEGER Not null;

  • i am still getting the same error message for this problem is there anything else you need to know before you can make a more informed answer? alter table movie_archive alter column RecordID INTEGER Not null; This is what i put in. Msg 5074, Level 16, State 1, Line 1 The object 'UQ__Movie_Ar__FBDF78C84C0144E4' is dependent on column 'RecordID'. Msg 4922, Level 16, State 9, Line 1 ALTER TABLE ALTER COLUMN RecordID failed because one or more objects access this column. this is the error i got. - kyle5385
  • ok you cannot alter if you have unique constraint on that column. drop that and recreate it - chetan

Linked

Related

Latest