The pubs2 Database

The sample database pubs2, 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.

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, SAP 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.

• Tables in the pubs2 Database
  In each of the tables in the pubs2 database, the column header specifies the column name, its datatype (including any user-defined datatypes), and its null or not null status. The column header also specifies any defaults, rules, triggers, and indexes that affect the column.
• Diagram of the pubs2 Database
  The diagram of the pubs2 database shows the database relationships among the tables.