Karlee  Will

Karlee Will

1625471938

Find Columns That Allows NULL In SQL Server

Introduction

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.

Using INFORMATION_SCHEMA.COLUMNS

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