stores Table

The stores table contains the names, addresses, ID numbers, and payment terms for stores.

stores is defined as:

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)

Its primary key is stor_id:

sp_primarykey stores, stor_id