Thread: My SQL shit keeps giving me errors!

DROP TABLE CUSTOMER;
DROP TABLE TRUCK;
DROP TABLE CITY;
DROP TABLE SHIPMENT;

CREATE TABLE CUSTOMER(
CUSTID VARCHAR(5) PRIMARY KEY,
CUSTNAME VARCHAR(45),
ANNUALREVENUE VARCHAR(12),
CUSTTYPE CHAR(1));

CREATE TABLE TRUCK(
TRUCK_NO VARCHAR(3) PRIMARY KEY,
DRIVERNAME VARCHAR(30));

CREATE TABLE CITY(
CITYNAME VARCHAR(30) PRIMARY KEY,
POPULATION VARCHAR(12));

CREATE TABLE SHIPMENT(
SHIPMENT_NO VARCHAR(4) NOT NULL,
CUSTID VARCHAR(5) NOT NULL,
WEIGHT VARCHAR(3),
TRUCK_NO VARCHAR(3)NOT NULL,
CITYNAME VARCHAR(30)NOT NULL,
SHIPDATE DATETIME,
PRIMARY KEY(SHIPMENT_NO, CUSTID),
FOREIGN KEY (CUSTID) REFERENCES CUSTOMER (CUSTID),
FOREIGN KEY (TRUCK_NO) REFERENCES TRUCK (TRUCK_NO),
FOREIGN KEY (CITYNAME) REFERENCES CITY (CITYNAME));

INSERT INTO CUSTOMER VALUES (102, 'FUTURE DYNAMICS', 7000000, 3);
INSERT INTO CUSTOMER VALUES (103, 'LOGICAL DESIGNS', 15000000, 2);
INSERT INTO CUSTOMER VALUES (104, 'CONCEPTUAL ENTITIES, INC', 18000000, 1);
INSERT INTO CUSTOMER VALUES (105, 'RELATIONAL MODELS', 2000000, 2);
INSERT INTO CUSTOMER VALUES (106, 'DEGREE CONSTRAINTS', 1000000, 1);
INSERT INTO CUSTOMER VALUES (107, 'INTEGRITY REQUIREMENTS', 14000000, 2);
INSERT INTO CUSTOMER VALUES (108, 'ATTRIBUTES DERIVED', 22000000, 1);
INSERT INTO CUSTOMER VALUES (109, 'STRUCTURED SOLUTIONS', 18000000, 3);
INSERT INTO CUSTOMER VALUES (110, 'FUNCTIONAL DEPENDENCIES, INC', 11000000, 2);
INSERT INTO CUSTOMER VALUES (111, 'ER DESIGNS', 6000000, 1);
INSERT INTO CUSTOMER VALUES (112, 'PHYSICAL IMPLEMENTATIONS', 1000000, 3);
INSERT INTO CUSTOMER VALUES (100, 'SPECIFIC MODELS', 9000000, 1);
INSERT INTO CUSTOMER VALUES (101, 'CARDINAL PRECISION', 12000000, 1);

INSERT INTO TRUCK VALUES(100, 'JONES');
INSERT INTO TRUCK VALUES(101, 'DAVIS');
INSERT INTO TRUCK VALUES(102, 'GOMEZ');
INSERT INTO TRUCK VALUES(103, 'THOMPSON');
INSERT INTO TRUCK VALUES(104, 'HERSHEY');
INSERT INTO TRUCK VALUES(105, 'FERRIS');
INSERT INTO TRUCK VALUES(106, 'SHAVER');
INSERT INTO TRUCK VALUES(107, 'LEE');
INSERT INTO TRUCK VALUES(108, 'TOPI');
INSERT INTO TRUCK VALUES(109, 'ACKERMAN');

INSERT INTO CITY VALUES('LONDON', 80000000);
INSERT INTO CITY VALUES('BLOOMINGTON', 67000);
INSERT INTO CITY VALUES('ATHENS', 54000);
INSERT INTO CITY VALUES('NASHVILLE', 1000000);
INSERT INTO CITY VALUES('TAMPA', 1250000);
INSERT INTO CITY VALUES('ATLANTA', 3500000);
INSERT INTO CITY VALUES('NEW YORK', 10000000);
INSERT INTO CITY VALUES('HOUSTON', 3800000);
INSERT INTO CITY VALUES('TUCSON', 1200000);
INSERT INTO CITY VALUES('LITTLE ROCK', 15000);
INSERT INTO CITY VALUES('BALTIMORE', 2100000);
INSERT INTO CITY VALUES('kNOXVILLE', 250000);

INSERT INTO SHIPMENT VALUES(1770, 100, 25, 100, 'LONDON', '12-Oct-03');
INSERT INTO SHIPMENT VALUES(1771, 101, 37, 103, 'TUCSON', '15-Oct-03');
INSERT INTO SHIPMENT VALUES(1772, 108, 15, 105, 'NASHVILLE', '1-Oct-03');
INSERT INTO SHIPMENT VALUES(1773, 101, 55, 102, 'NEW YORK', '21-Oct-03');
INSERT INTO SHIPMENT VALUES(1774, 102, 95, 108, 'BALTIMORE', '20-Oct-03');
INSERT INTO SHIPMENT VALUES(1774, 103, 45, 108, 'BALTIMORE', '22-Oct-03');
INSERT INTO SHIPMENT VALUES(1774, 106, 80, 108, 'BALTIMORE', '27-Oct-03');
INSERT INTO SHIPMENT VALUES(1775, 105, 60, 109, 'KNOXVILLE', '27-Sep-03');
INSERT INTO SHIPMENT VALUES(1775, 108, 80, 109, 'LITTLE ROCK', '15-Sep-03');
INSERT INTO SHIPMENT VALUES(1776, 110, 70, 100, 'BLOOMINGTON', '8-May-03');
INSERT INTO SHIPMENT VALUES(1777, 112, 30, 100, 'ATHENS', '10-Jun-03');

So that's the SQL that I've written but I keep getting two errors (depending on when I execute the query).

Msg 3726, Level 16, State 1, Line 2
Could not drop object 'CUSTOMER' because it is referenced by a FOREIGN KEY constraint.
Msg 3726, Level 16, State 1, Line 3
Could not drop object 'TRUCK' because it is referenced by a FOREIGN KEY constraint.
Msg 3726, Level 16, State 1, Line 4
Could not drop object 'CITY' because it is referenced by a FOREIGN KEY constraint.
Msg 2714, Level 16, State 6, Line 7
There is already an object named 'CUSTOMER' in the database.

or

Msg 3701, Level 11, State 5, Line 5
Cannot drop the table 'SHIPMENT', because it does not exist or you do not have permission.

All the data makes it to the tables, but I'm not sure if the errors are causing any problems, and I don't want to have points taken off because the damned query is somehow jacked. Anyone have any ideas as to what I'm missing? (First real attempt at SQL here so I'm still iffy as to what i'm doing)

Oh and if it makes a difference i'm running the queries in SQL Server 2005.