---

Search posts under SQL Server:

---

Nullable column in SQL Server

How to and why to specify a database table column as null in SQL Server?

Let’s first understand the difference between NULL and Empty

• NULL – is the absence of value that is completely blank
• Empty – is a string that is empty

To make a column nallable (that can hold null value), we to check “Allow Nulls” checkbox at the time of creating/designing the database table.

Notice the above picture, where LastName, Age, and Active column Allow Nulls checkbox is checked that means that these fields will acccept null value in the database table.