/ Published in: SQL
Expand |
Embed | Plain Text
ALTER TABLE dbo.[TABLE] ADD [COLUMN] bit NULL CONSTRAINT [COLUMN]Dflt DEFAULT 0 WITH VALUES GO ALTER TABLE [TABLE] ALTER COLUMN [COLUMN] bit NOT NULL GO
You need to login to post a comment.
ALTER TABLE dbo.[TABLE] ADD [COLUMN] bit NULL CONSTRAINT [COLUMN]Dflt DEFAULT 0 WITH VALUES GO ALTER TABLE [TABLE] ALTER COLUMN [COLUMN] bit NOT NULL GO
You need to login to post a comment.