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