Results 1 to 3 of 3
Thread: My SQL shit keeps giving me errors!
-
10-12-10, 09:22 AM #1
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');
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.
Msg 3701, Level 11, State 5, Line 5
Cannot drop the table 'SHIPMENT', because it does not exist or you do not have permission.
Oh and if it makes a difference i'm running the queries in SQL Server 2005.Last edited by Rawr; 10-12-10 at 09:25 AM.
-
-
Thread Information
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks