SQL Server - How make allow NULL value in column

Question

I'm newbie level in SQL Server

I want to allow null value in column, but it can't save.

So I will re-create a new table with same structure.

Please your help to allow null value in column with SQL script. Thank you..

Answer 1

It looks as though the designer is trying to re-create the whole table and warning you about that.

It is possible to allow it to do so by disabling the option specified in the error message to "prevent saving changes that require the table to be recreated" but there is no need for this here.

You can just run

ALTER TABLE SAMPLE_UPL
  ALTER COLUMN KORESKI VARCHAR(300) NULL

Or simply

ALTER TABLE SAMPLE_UPL
  ALTER COLUMN KORESKI VARCHAR(300) 

(as altering an existing column always sets it to allow NULL unless explicitly specified otherwise)