Hi,

I'm using below code to get column list with null value. I'm using dbvisualizer.

DECLARE
@ColumnName nvarchar(500)
,@DataType nvarchar(128)
,@cmd nvarchar(max)
,@TableSchema nvarchar(128) = 'dbo'
,@TableName sysname = 'testtable';

DECLARE getinfo CURSOR FOR
SELECT
c.COLUMN_NAME
,c.DATA_TYPE
FROM
INFORMATION_SCH EMA.COLUMNS...