The publishers table contains the publisher name and id, city, and state of publishers in the pubs2 database.
publishers is defined as follows:
create table publishers (pub_id char(4) not null, pub_name varchar(40) not null, city varchar(20) null, state char(2) null)
Its primary key is pub_id:
sp_primarykey publishers, pub_id
Its pub_idrule rule is defined as:
create rule pub_idrule
as @pub_id in
("1389", "0736", "0877", "1622", "1756")
or @pub_id like "99[0-9][0-9]"
