Navigation

	Home Page
	Index
	All Pages

Contributor Links

	Create a new Page
	Administration
	File Management
	Login/Logout
	Your Profile

Other Wiki Sections

Software

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)