>Hi everybody,
>
>I have this script
>
>ALTER TABLE People ALTER COLUMN IsActive bit NOT NULL CONSTRAINT [DF_People_IsActive] DEFAULT 1
>
>and it's not working. I need to add a new constraint to a field. How can I do this?
>
>Thanks.
The syntax is definitely not trivial
ALTER TABLE dbo.People ADD CONSTRAINT
DF_People_IsActive DEFAULT 1 FOR IsActive
If it's not broken, fix it until it is.
My Blog