Appendix A: The pubs2 Database

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

The pubs2 database also lists primary and foreign keys, rules, defaults, views, triggers, and stored procedures used to create these tables.

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

For information about installing pubs2, see the installation guide for your platform.

To change the sample database using create or data modification statements, you may need to get additional permissions from a system administrator. If you do change the sample database, Sybase suggests that you return it to its original state for the sake of future users. Ask a system administrator if you need help restoring the sample databases.