Is it possible to get all the null values containing columns

Question

Dear All Is it possible to get all the null values containing columns from database ? Thanks

Daisy Princess · Answer

You can run the below script to find all nullable column of a table :- SELECT * FROM INFORMATION_SCHEMA.COLUMNS c WHERE TABLE_NAME='Table1' AND IS_NULLABLE ='YES'