Re: script error

[David Childers]

Here's a translation of your CREATE TABLE statement. You might want to try it, but no guarantees it will work:

CREATE TABLE Customers (Customer# SMALLINT, LastName VARCHAR(10) NOT NULL, FirstName VARCHAR(10) NOT NULL, Address VARCHAR(20), City VARCHAR(12), State VARCHAR(2), Zip VARCHAR(5), Referred SMALLINT, Region CHAR(2), CONSTRAINT customers_customer#_pk PRIMARY KEY(customer#), CONSTRAINT customers_region_ck CHECK (region IN ('N', 'NW', 'NE', 'S', 'SE', 'SW', 'W', 'E')) );