Appendix A: The pubs2 Database

blurbs table

The blurbs table contains sample blurbs for books in the pubs2 database

. blurbs is defined:

create table blurbs
(au_id  id not null,
copy text null)

Its primary key is au_id:

sp_primarykey blurbs, au_id

Its au_id column is a foreign key to authors:

sp_foreignkey blurbs, authors, au_id