sales table  store_employees table

Appendix B: The pubs3 Database

stores table

The stores table contains the store id, store name, and other information about stores in the pubs3 database.

stores is defined as follows:

create table stores
(stor_id char(4) not null,
stor_name varchar(40) not null,
stor_address varchar(40) null,
city varchar(20) null,
state char(2) null,
country varchar(12) null,
postalcode char(10) null,
payterms varchar(12) null,
unique nonclustered (stor_id))




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

View this book as PDF