Tables in the pubs3 database  authors table

Appendix B: The pubs3 Database

publishers table

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. authors table

View this book as PDF