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.

Tables in the pubs2 database

publishers table

authors table

titles table

titleauthor table

salesdetail table

sales table

stores table

roysched table

discounts table

blurbs table

au_pix table

Diagram of the pubs2 database


	Expand Search