Readpast-locking examples  Tables in the pubs2 database


Appendix A: The pubs2 Database

This appendix describes the sample database pubs2. This database 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 Configuring Adaptive Server Enterprise for your platform.





Copyright © 2005. Sybase Inc. All rights reserved. Tables in the pubs2 database

View this book as PDF