TSQL - Change a column from nullable to non nullable

ALTER TABLE [DATABASE_NAME].[SCHEMA_NAME].[TABLE_NAME] 

ALTER COLUMN [Column Name] varchar(8) NOT NULL;