A SQL query to find all columns in a table that is not nullable (good to have ie when populating a table for testing)

FindNotNullable.sql

USE      DATABASENAME
DECLARE  @table varchar(250) = 'TABLENAME'

SELECT   name, is_nullable 
FROM     sys.columns 
WHERE    object_id = object_id(@table)
AND      is_nullable = 0
ORDER BY name