Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
The pubs2 sample schema is used as the consolidated database schema. It contains information about stores, titles, authors, publishers, and sales. The following table provides a description of each table in the Adaptive Server Enterprise database:
|au_pix||Pictures of the authors.|
|authors||The authors of the various titles in the system.|
|discounts||Records of various discounts at particular stores.|
|sales||Each sale record is one sale made by a particular store.|
|salesdetail||Information about the different titles that were included in a particular sale.|
|stores||Each store record is one store or branch office in the system.|
|titleauthor||Information about which titles were written by which authors.|
|titles||Records of all the different books in the system.|
|blurbs, publishers, and roysched||Information that is not needed in this tutorial.|
Discuss this page in DocCommentXchange.
|Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1|