(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?
Transcribed Image Text:
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) 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)
Expert Answer:
Answer rating: 100% (QA)
To find the primary key constraint name for the Customer table you can query the data dictionary vie... 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
-
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....
-
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...
-
(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...
-
Elena, a student in F-1 immigration status from Romania, is on the basketball team. She arrived in the U.S. on June 18, 2023 on a full athletic scholarship that includes $10,000 for her room and...
-
What two main obstacles prevent us from traveling today throughout the galaxy at relativistic speeds?
-
A cyclic coordinate \(q_{k}\) is a coordinate absent from the Lagrangian (even though \(\dot{q}_{k}\) is present in L.) (a) Show that a cyclic coordinate is likewise absent from the Hamiltonian. (b)...
-
130 Use divisibility rules to determine if each of the following is divisible by 5 .
-
Hollings Company sells and delivers office furniture in the Rocky Mountain area. The costs associated with the acquisition and annual operation of a delivery trucks are given below: Required: 1....
-
Thank you! Problem 1 The analyst is analyzing the ?nancial statements of another Yettobe corporation (the state?? ments are in million dollars). Its stock is currently traded at $50 and it has 20 m...
-
The owner of Neros company has hired you to analyze her company's performance and financial position, as well as the positions of Iits competitors, Centar and Xermix. However, the data Neros abtained...
-
Sometimes finding job openings is about asking the right questions (of the right people) and checking websites. These sources are usually free, while employment agencies may charge for their...
-
Ann the astronaut weighs 60 kg and pushes a stationary 350 kg satellite while on a space walk. The speed of the satellite is .9 m/s after the push. What is her recoil speed?
-
Ehrlich Co. began business on January 2. Salaries were paid to employees on the last day of each month, and social security tax, Medicare tax, and federal income tax were withheld in the required...
-
Based on the following data, determine the total assets, total liabilities, net worth, total cash inflows, and total cash outflows. Balance Sheet and Cash Flow Items Rent for the month Cash in...
-
Why do you consider it extremely important, before starting the financial study, to know the investment plan of the company?
-
Economics professors like to ask their students about the diamond-water paradox: Why is it that a good that is as essential to human existence as water costs so much less than a good like a diamond...
-
Outdoor Luggage, Inc., makes high-end hard-sided luggage for sports equipment. Data concerning three of the company's most popular models appear below. Ski Guard. Golf Guard Fishing Guard Selling...
-
Respond to the ethical judgments required based on the following scenarios. Scenario 1. Assume you have collected a sample using MUS and that you have evaluated that sample to calculate a total...
-
In the 2012 tax year, Michelle paid the following amounts relating to her 2010 tax return: Tax deficiency..........................................$5,000 Negligence...
-
Carl and Jenny adopt a Russian orphan. The adoption takes 2 years and two trips to Russia and is final in 2012. They pay $6,000 in 2011 and $7,500 in 2012 of qualified adoption expenses, and have AGI...
-
Cedar Corporation has an S corporation election in effect. During the 2012 calendar tax year, the corporation had ordinary taxable income of $200,000, and on January 15, 2012, the corporation paid...
-
Question: Aditi and Danielle, MBA students, need an apartment for next September. They find a lovely two-bedroom unit that the owner is rehabbing. The students can see that the owner is honest, his...
-
Question: Ron buys 1,000 "Smudgy Dolls" for his toy store. Karen, the seller, tells him the dolls are in perfect condition, even though she knows their heads are defectively attached. Ron sells all...
-
Question: Donald Waide had a contracting business. He bought most of his supplies from Paul Bingham's supply center. Waide fell behind on his bills, and Bingham told Waide that he would extend no...
Study smarter with the SolutionInn App