3
CUSTOMERID varchar(5) NOT NULL,
4
COMPANYNAME varchar(40) NOT NULL,
5
CONTACTNAME varchar(30),
6
CONTACTTITLE varchar(30),
10
POSTALCODE varchar(10),
14
PRIMARY KEY(CUSTOMERID)
17
CREATE INDEX CUSTOMERS_CITY_IDX (CITY) ON CUSTOMERS;
18
CREATE INDEX CUSTOMERS_COMPANYNAME_IDX (COMPANYNAME) ON CUSTOMERS;
19
CREATE INDEX CUSTOMERS_POSTALCODE_IDX (POSTALCODE) ON CUSTOMERS;
20
CREATE INDEX CUSTOMERS_REGION_IDX (REGION) ON CUSTOMERS;