SELECT column_name FROM table_name WHERE column_name IS NULL;
SELECT COLUMNPROPERTY(OBJECT_ID('SchemaName.TableName', 'U'), 'ColumnName', 'AllowsNull');