Thursday, October 21, 2010

Add Column the safe way


if not exists ( select 1 from sys.tables t
join sys.columns c on c.object_id = t.object_id
where t.name = 'Users' and c.name = 'IsAdmin')
BEGIN
ALTER TABLE Users
ADD IsAdmin bit NOT NULL
END
GO

No comments: