The publishers table contains the publisher id, name, city, and state for each publisher in the pubs3 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, unique nonclustered (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]"
Copyright © 2005. Sybase Inc. All rights reserved. |