Adding a Constraint.

Question

I need to add a constraint to various Feilds in my table.

On executing the following code I get Incorrect Syntax by Constraint. Please see attached code

All help highly regarded

R

ALTER TABLE [Nop].[dbo].[Product]
Alter Column PacksPerLayer int NOT NULL 
CONSTRAINT CK_Product_PacksPerLayer DEFAULT '0'
GO

Answer 1

ALTER TABLE [Nop].[dbo].[Product]
ADD [PacksPerLayer] INT NOT NULL 
CONSTRAINT [CK_Product_PacksPerLayer] DEFAULT '0'

---

Jon

Answer 2

Column is already there I need to just add the constraint Is It possible?

Answer 3

ALTER TABLE [Nop].[dbo].[Product] ADD CONSTRAINT [CK_Product_PacksPerLayer] DEFAULT '0' FOR [PacksPerLayer]

---

Jon