Jasinski Technical Wiki

Navigation

Home Page
Index
All Pages

Quick Search
»
Advanced Search »

Contributor Links

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

Other Wiki Sections

Software

PoweredBy

DDL Syntax - SQL Server

RSS
Modified on Tue, Sep 20, 2011, 9:50 AM by Administrator Categorized as 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)

ScrewTurn Wiki version 3.0.1.400. Some of the icons created by FamFamFam. Except where noted, all contents Copyright © 1999-2018, Patrick Jasinski.