5> CREATE TABLE sales
6> (order_no INTEGER NOT NULL PRIMARY KEY,
7> order_date DATETIME NOT NULL,
8> ship_date DATETIME NOT NULL)
9> GO
1>
2> ALTER TABLE sales
3> ADD CONSTRAINT order_check CHECK(order_date <= ship_date)
4> GO
1>
2>
3> ALTER TABLE sales
4> DROP CONSTRAINT order_check
5> GO
1>
2> drop table sales;
3> GO