Loading

How to find null or empty column names in a sql table

r k

5y3.9kSQL

I need a query that provides me all the column names not data from a SQL table that does not have any value just the name of the columns, which is basically null or empty columns sitting in the table. Please help

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

geetha velusamy4y ago
Sql Query to find NULL or EMPTY Column in SQL:

SELECT * FROM table_name WHERE NULLIF(col_name, ' ') IS NULL;

-1
Sachin Singh5y ago
1. DECLARE @table VARCHAR(100) = 'dbo.yourtableName'
3. DECLARE @sql NVARCHAR(MAX) = ''
5. SELECT @sql = @sql + 'IF NOT EXISTS(SELECT 1 FROM ' + @table + ' WHERE ' + c.name + ' IS NOT NULL) PRINT ''' + c.name + ''''
6. FROM sys.objects o
7. JOIN sys.columns c ON o.[object_id] = c.[object_id]
8. WHERE o.[type] = 'U'
9. AND o.[object_id] = OBJECT_ID(@table)
10. AND c.is_nullable = 1
12. EXEC(@sql)
+1