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

Page 2 of 4 1 2 3 4 5 6 7 8 665 words Script Output xQuery Result x 9 select * from customer Use ONE SQL  (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?

Page 2 of 4 1 2 3 4 5 6 7 8 665 words Script Output x Query Result x 9 select * from customer 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. SQL | All Rows Fetched: 9 in 0.092 seconds CUSTID NAME ADDRESS 345 VIEWRIDGE 490 BOLI RD. 9722 HAMILTON HILLVIEW MALL 100 JOCKSPORTS 101 TKB SPORT SHOP 102 VOLLYRITE 103 JUST TENNIS 104 EVERY MOUNTAIN 105 KI SPORTS 574 SUYYYYY RD. 3476 EL PASEO 908 SEQUOIA VALCO VILLAGE 106 SHAPE UP 107 WOMENS SPORTS SUNNYVALE 108 NORTH WOODS HEALTH AND FITNESS SUPPLY CENTER 98 LONE PINE WAY HIBBING CITY BELMONT CA REDWOOD CITY CA BURLINGAME CA BURLINGAME CA CUPERTINO CA SANTA CLARA CA PALO ALTO CA CA MN Focus 88 B 6 STATE ZIP ZIP AREA 96711 94061 95133 97544 93301 91003 94301 93301 55649 AREA PHONE 415 598-6609 415 368-1223 415 644-3341 415 677-9312 408 996-2323 408 376-9966 415 364-9777 408 967-4398 612 566-9123 + REPID CREDITLIMIT 7844 7521 7654 7521 7499 7844 7521 7499 7844 + 100% COMMENTS 5000 Very friendly people 10000 Rep called 5/8 about 7000 Company doing heavy 1 3000 Contact rep about ne 10000 Customer with high m 5000 Tends to order large. 6000 Support intensive. 0: 10000 First sporting goods 8000 (null)

Step by Step Solution

3.36 Rating (146 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

To find the primary key constraint name for the Customer table you can query the data dictionary vie... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!