The stores table contains the names, addresses, id numbers, and payment terms for stores in the pubs2 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)
Its primary key is stor_id:
sp_primarykey stores, stor_id
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
