Mega Code Archive

 

Categories / MSSQL Tutorial / Table

 

Each declarative integrity constraint can be removed using the DROP clause of the ALTER TABLE statement

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