Compare Page Revisions
« Older Revision - Back to Page History - Newer Revision »
if COL_LENGTH('TableName','ColumnName') is not null alter table dbo.TableName drop column ColumnName
alter table dbo.TableName ADD ColumnName int not null identity(1,1) ,ColumnName2 date not null ,ColumnName3 varchar(3) null constraint DF_TableName_ColumnName3 DEFAULT 'XYZ' WITH VALUES
ScrewTurn Wiki version 3.0.1.400. Some of the icons created by FamFamFam. Except where noted, all contents Copyright © 1999-2024, Patrick Jasinski.