Mega Code Archive

 

Categories / MSSQL Tutorial / Constraints

 

Use or to link two conditions for check constraint

2>  CREATE TABLE publishers 3> ( 4>    pub_id         char(4)           NOT NULL 5>          CONSTRAINT UPKCL_pubind PRIMARY KEY CLUSTERED 6>          CHECK (pub_id in ('1389', '0736', '0877', '1622', '1756') OR pub_id like '99[0-9][0-9]'), 7> 8>    pub_name       varchar(40)           NULL, 9>    city           varchar(20)           NULL, 10>    state          char(2)               NULL, 11> 12>    country        varchar(30)           NULL 13> 14>          DEFAULT('USA') 15> ) 16> 17> GO