How to create constraint in SQL Server 2008

Question

I want to create constraint orderDate must be smaller than deliveryDate? Help me.

Have u tried anything???? First try by yourself and if u r not getting then ask the question.... — The Hungry Dictator, Nov 11 '13 at 09:21
`ALTER TABLE YourTable ADD CONSTRAINT CK_orderDate_Before_deliveryDate CHECK(orderDate < deliveryDate)` — Martin Smith, Nov 11 '13 at 09:23

score 2 · Answer 1 · edited Nov 11 '13 at 10:10

2

Supposing the table name is MyTable:

ALTER TABLE [dbo].[MyTable] WITH CHECK 
ADD CONSTRAINT [CK_MyTable_date1] CHECK (orderDate <= deliveryDate)

ALTER TABLE [dbo].[MyTable] CHECK CONSTRAINT [CK_MyTable_date1]
GO

edited Nov 11 '13 at 10:10

marc_s

732,580
175
1,330
1,459

answered Nov 11 '13 at 09:24

bjnr

3,353
1
18
32

score 1 · Answer 2 · edited May 23 '17 at 12:33

There are two ways to do it.

First While creating the table and after the creation:

While creating the table:

CREATE TABLE Price (
PriceID INT PRIMARY KEY IDENTITY (1,1),
OriginalPrice FLOAT NOT NULL,
CurrentPrice FLOAT NOT NULL,
Discount FLOAT,
ShippingCost FLOAT NOT NULL,
Tax FLOAT NOT NULL,
CHECK (CurrentPrice <= OriginalPrice));

After creation the table:

ALTER TABLE Price ADD CHECK (CurrentPrice <= OriginalPrice);
--or
ALTER TABLE Price ADD CONSTRAINT CK_Price_Current_vs_Original
CHECK (CurrentPrice <= OriginalPrice);

You can go for the date fields in the same sense. For more info please Read this.

How to create constraint in SQL Server 2008

2 Answers2