Question

(Using Oracle SQL) How do I find the primary key of this table? And then how do I consequently drop the primary key from the table?

Q7 (10 Points) Use ONE SQL statement to find out the name of the primary key constraint defined on Customer table. (Your SQL should return something like SYS_C0021715, numbers on your account may differ.) Then use another SQL statement to drop the primary key constraint for Customer table (because it is defined on the wrong column). You can use multiple SQL statements to accomplish this. Page 2 of 4 665 words Focus 1 + 100% select * from customer Script Output x Query Result x ER SQL | All Rows Fetched: 9 in 0.092 seconds CUSTID NAME ADDRESS E CITY STATE ZIP AREA PHONE 1 100 JOCKSPORTS 345 VIEWRIDGE BELMONT CA 96711 415 598-6609 2 101 TKB SPORT SHOP 490 BOLI RD. REDWOOD CITY CA 94061 415 368-1223 3 102 VOLLYRITE 9722 HAMILTON BURLINGAME CA 95133 415 644-3341 4 103 JUST TENNIS HILLVIEW MALL BURLINGAME CA 97544 415 677-9312 5 104 EVERY MOUNTAIN 574 SUYYYYY RD. CUPERTINO CA 93301 408 996-2323 6 105 K + T SPORTS 3476 EL PASEO SANTA CLARA CA 91003 408 376-9966 7 106 SHAPE UP 908 SEQUOIA PALO ALTO CA 94301 415 364-9777 8 107 WOMENS SPORTS VALCO VILLAGE SUNNYVALE CA 93301 408 967-4398 9 108 NORTH WOODS HEALTH AND FITNESS SUPPLY CENTER 98 LONE PINE WAY HIBBING MN 55649 612 566-9123 REPID CREDITLIMIT COMMENTS 7844 5000 Very friendly people 7521 10000 Rep called 5/8 about 7654 7000 Company doing heavy i 7521 3000 Contact rep about ner 7499 10000 Customer with high m. 7844 5000 Tends to order large 7521 6000 Support intensive. O: 10000 First sporting goods 7844 8000 (null) 7499

Edit: I was already give this code and it did not work

select constraint_name,constraint_type from user_constraint where table_name='CUSTOMER';

Answer 1

ANSWER:

• I have provided the properly commented code in both text and image format so you can easily copy the code as well as check for correct indentation.
• Have a nice and healthy day!!

CODE TEXT

-- Retrieve Primary ke information
SELECT cols.table_name, cols.column_name, cols.position, cons.status, cons.owner
FROM all_constraints cons, all_cons_columns cols
WHERE cols.table_name = 'CUSTOMER' -- Table Name
AND cons.constraint_type = 'P' -- Primary key constraint type
AND cons.constraint_name = cols.constraint_name
AND cons.owner = cols.owner
ORDER BY cols.table_name, cols.position;

-- Droping PRIMARY KEY constraint
ALTER TABLE CUSTOMER
DROP CONSTRAINT CUSTID; -- Primary Key col

CODE IMAGE

1 2 3 4 5 6 7 8 9 10 11 12 Retrieve Primary ke information SELECT cols.table_name, cols.column_name, cols.position, cons.status, cons.owner FROM all_constraints cons, all_cons columns cols WHERE cols.table_name = 'CUSTOMER' -- Table Name AND cons.constraint_type = 'P' Primary key constraint type AND cons.constraint_name = cols.constraint_name AND cons.owner = cols.owner ORDER BY cols.table_name, cols.position; Droping PRIMARY KEY constraint ALTER TABLE CUSTOMER DROP CONSTRAINT CUSTID; Primary key col 13