(Using Oracle SQL) How do I find the primary key of this table? And then how do...
Fantastic news! We've Found the answer you've been seeking!
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?
Edit: I was already give this code and it did not work
select constraint_name,constraint_type from user_constraint where table_name='CUSTOMER';
Transcribed Image Text:
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 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
Expert Answer:
Answer rating: 100% (QA)
Based on the image provided it seems that the SQL code snippet was meant to query the constraints of ... View the full answer
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these databases questions
-
7. A small, omnidirectional sound source at the position (x, y, z) = (0, 0, 0.01 mm) radiates with a wavelength 2 mm. The radiated intensity is measured at the position (x, y, z) = (0, 0, 100 mm) The...
-
The beam in the figure below has the central half of the beam enlarged so that the moment of inertia is twice the value for each end section. Determine the deflection at the center of the beam....
-
You are asked to develop a Floppy Disk program that allows users to access a floppy disk locally mounted on a computer. You are expected to use C programming language. In your program, all file I/O...
-
Jogger 1 is travelling east at 6 . 5 m / s and has a mass of 8 2 kg . Jogger 2 is travelling north at 5 . 8 m / s and has a mass of 5 4 . 5 kg . One of the joggers has their head down and doesnt see...
-
If a high-speed spaceship appears shrunken to half its normal length, how does its momentum compare with the classical formula p 5 mv?
-
The two stars in a double-star system circle one another gravitationally, with period \(T\). If they are suddenly stopped in their orbits and allowed to fall together, show that they will collide...
-
Make a list of the common divisors of 12 and 18 . What is the GCD of 12 and 18 ? Which of the other common divisors of 12 and 18 divide the GCD?
-
The monthly sales for Yazici Batteries, Inc., were as follows: Month ........... Sales January ........... 20 February ............ 21 March ............. 15 April ............. 14 May .................
-
?(Related to Checkpoint? 5.4) ? (Present value) Sarah Wiggum would like to make a single investment and have ?$ 1.5 million at the time of her retirement in 28 years. She has found a mutual fu...
-
Keuka Studies does custom metal sculptures of horses and other animals. A horse sculpture is composed of numerous parts. They use a lathe to construct two types of parts. The Body part is used to...
-
The graph of the function f is given below. You do not need show your work in this problem. 10 10 10. (a) (2pts) Find the domain of f. (b) (3pts) Find f(-2), f(0) and f(10). (c) (2pts) Find the...
-
Why should an analyst review more than one year of financial statements before projecting an agency's revenues and expenditures? provide references
-
1. Distinguish between debentures and mortgage bonds. 2. a. How does a bond's par value differ from its market value? b. Explain the differences among a bond's coupon interest rate, current yield,...
-
State the invariants point when y= x - 25 transformed to y= x2 - 25
-
In 2024, the Westgate Construction Company entered into a contract to construct a road for Santa Clara County for $10,000,000. The road was completed in 2026. Information related to the contract is...
-
Assume that Fancy company has long term debt/equity ratio of 3 . Its $1,000 par value, 10-year, 8.5% bonds with semiannual payments are selling for $925.00. The beta is 1.5, and the yield on a...
-
1. Your company name and the country you have chosen. (Get creative with a great cover!) 2. Your MISSION STATEMENT FOR YOUR COMPANY - why is this important based on your product and company? 3. What...
-
Organizations are increasing their use of personality tests to screen job applicants. What are some of the advantages and disadvantages of this approach? What can managers do to avoid some of the...
-
Larry Gaines, age 42, sells his personal residence on November 12, 2012, for $144,000. He lived in the house for 7 years. The expenses of the sale are $10,500, and he has made capital improvements of...
-
Leslie and Leon Lazo are married and file a joint return for 2012. Leslie's Social Security number is 466-47-3311 and Leon's is 467-74-4451. They live at 143 Snapdragon Drive, Reno, NV 82102. For...
-
Sally hires a maid to work in her home for $250 per month. The maid is 25 years old and not related to Sally. During 2012, the maid worked 10 months for Sally. a. What is the amount of Social...
-
What is an example of an inexpensive loan, a medium-priced loan, and an expensive loan?
-
Banks offer many savings options to teenagers. A teen can open a savings/passbook account or a CD (certificate of deposit).
-
How might you select a card that best meets your needs?
Study smarter with the SolutionInn App