Appendix A: The pubs2 Database

This appendix describes the sample database pubs2. This database contains the tables publishers, authors, titles, titleauthor, au_pix, salesdetail, sales, stores, discounts, roysched, and blurbs.

The pubs2 database also contains primary and foreign keys, rules, defaults, views, triggers, and stored procedures.

A diagram of the pubs2 database appears in Figure A-2.

For information about installing pubs2, see the Configuring Adaptive Server Enterprise for your platform.