How to Change a Column to Allow NULL in SQL Server

  • google plus

In Brief...

If you have a column in a SQL Server table that does not allow NULL values and you need to change it to allow NULLs, here is how you do it.

Take our Introduction to SQL Training course for free.

See the Course Outline and Register

Instructions

Let's say, you created a table like this:

CREATE TABLE Employees (
  EmployeeID int NOT NULL AUTO_INCREMENT,
  FirstName NVARCHAR(25) NOT NULL,
  LastName NVARCHAR(25) NOT NULL
);

Then you hire Madonna and realize you need to make LastName nullable. Here's how you change it.

ALTER TABLE Employees ALTER COLUMN LastName NVARCHAR(25) NULL;

Author: Nat Dunn

Nat Dunn founded Webucator in 2003 to combine his passion for web development with his business expertise and to help companies benefit from both.

Discuss