Karlee  Will

Karlee Will


Find Columns That Allows NULL In SQL Server


The columns in a table, that allows NULL in a database sometimes can lead to performance issues. The Nullable columns may be one of the reason to lead query to performance bad. By making columns NOT NULL can help the query to perform well. In this article we will discuss a simple way to find table columns that allows NULL.


INFORMATION_SCHEMA.COLUMNS view results information about all the columns for all tables and views in a current database. This view has a column as IS_NULLABLE, which holds the information about the columns is NULLABLE or NOT. If NULLABLE, then results as YES and not nullable, then results as NO.

#sql server #sql #ssms

Find Columns That Allows NULL In SQL Server