Tag Archives: nullable

Identify Null Columns and Data Null Columns

I saw an interesting question in Facebook group. It’s all related to NULL values.. How to identify NULLable columns in a table and column with data as NULL. I thought of searching it in internet and pointing him to the link but I couldn’t get a reliable post to point it to the user so I finally wrote it. This script will just give you information about nullable columns in a table and whether the nullable column has null values. You can either scan NULL data or you can skip it. Continue reading Identify Null Columns and Data Null Columns