DDL Syntax - SQL Server

Add Column

alter table MyTable add MyColumn int not null

Alter Column

alter table MyTable alter column MyColumn int not null

Create Foreign Key

alter table OnTable with check
add constraint FK_OnTable_AgainstTable_OnColumn
foreign key (OnColumn)
references AgainstTable (AgainstColumn)