TSQL - Adding an identity column to an existing table

alter table DB.dbo.TABLE add RecordID INT IDENTITY;

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;