Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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

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

Page 2 of 4 665 words select * from customer 1 2 3 4 5 6 7 8 9 Script Output x Query Result x SQL 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. All Rows Fetched: 9 in 0.092 seconds CUSTID NAME ADDRESS 100 JOCKSPORTS 101 TKB SPORT SHOP 102 VOLLYRITE 103 JUST TENNIS 345 VIEWRIDGE 490 BOLI RD. 9722 HAMILTON HILLVIEW MALL 574 SUYYYYY RD. 3476 EL PASEO 908 SEQUOIA VALCO VILLAGE 104 EVERY MOUNTAIN 105 KI SPORTS 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 STATE ZIP 96711 94061 95133 97544 93301 91003 94301 93301 55649 00 B 7 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 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 net 10000 Customer with high m 5000 Tends to order large 6000 Support intensive. O: 10000 First sporting goods 8000 (null) CREDITLIMIT

Step by Step Solution

There are 3 Steps involved in it

Step: 1

Based on the image provided it seems that the SQL code snippet was meant to query the constraints of ... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Income Tax Fundamentals 2013

Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill

31st Edition

1111972516, 978-1285586618, 1285586611, 978-1285613109, 978-1111972516

More Books

Students also viewed these Databases questions

Question

What is the persons job (e.g., professor, student, clinician)?

Answered: 1 week ago