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.

enter link description here

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..

there is no attached picture (and I don't think you'll be able to attach, your rep is too low), so your question makes no sense. Please explain yourself — Amit
– Amit, Commented May 30, 2015 at 16:31
@Amit - the image was in the question markdown stackoverflow.com/posts/30548532/edit/… — Martin Smith
– Martin Smith, Commented May 30, 2015 at 18:17

Martin Smith · Accepted Answer · 2015-05-30 18:13:36Z

10

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)

answered May 30, 2015 at 18:13

Martin Smith

457k97 gold badges777 silver badges887 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

tjeloep Over a year ago

i think this one is better answer as it describes the root cause of the OP's problem and provides simplest solution. [+1]

wiretext · Accepted Answer · 2015-05-30 16:48:02Z

3

go in table design and checked check box this can allow you null values enter image description here

script of this table

CREATE TABLE [dbo].[AWBuildVersion](
    [SystemInformationID] [tinyint] IDENTITY(1,1) NOT NULL,
    [Database Version] [nvarchar](25) NULL,
    [VersionDate] [datetime] NOT NULL,
    [ModifiedDate] [datetime] NOT NULL,
 CONSTRAINT [PK_AWBuildVersion_SystemInformationID] PRIMARY KEY CLUSTERED 
(
    [SystemInformationID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

edited May 30, 2015 at 16:48

answered May 30, 2015 at 16:34

wiretext

3,35216 silver badges19 bronze badges

Collectives™ on Stack Overflow

SQL Server - How make allow NULL value in column

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related