salesdetail table  stores table

Appendix B: The pubs3 Database

sales table

The sales table contains the store id, order number, and date of sales in the pubs3 database.

sales is defined as follows:

create table sales
(stor_id char(4) not null
    references stores(stor_id),
ord_num numeric(6,0) identity,
date datetime not null,
unique nonclustered (ord_num))




Copyright © 2005. Sybase Inc. All rights reserved. stores table

View this book as PDF