SELECT COLUMN_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE
TABLE_SCHEMA = 'PRODUCTION'
AND TABLE_NAME = 'PRODUCT'
AND IS_NULLABLE = 'NO'
AND COLUMN_DEFAULT IS NULL