(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...
-
The cable OA exerts force F on point O. If the length of the cable is L, what are the coordinates (x, y, z) of point A? Given: F = (40 60 70) L = 3 m A(x, y, z)
-
How much pressure is applied to the ground by a 56 kg man who is standing on square stilts that measure 0.06 m on each edge? Answer in units of Pa. 003 (part 2 of 2) 10.0 points What is this pressure...
-
Identify the five objectives of a sales presentation and develop an example of how a sales presentation would accomplish each one.
-
Dandy Hardware Stores reported the following asset values in 2010 and 2011: In addition, Dandy Hardware had sales of $3,500,000 in 2011. Cost of goods sold for the year was $2,200,000. Compute Dandy...
-
Below is the Unadjusted Trial Balance for Allan dated December 3 1 , 2 0 1 9 : Allan Castillo Unadjusted Trial Balance 3 1 - Dec - 1 9 Account Name Debits Credits Cash 3 2 , 8 0 0 . 0 0 Accounts...
-
The graph below shows supply and demand curves for a new mp3 player accessory. a. What is the equilibrium price? b. Describe the relationship of supply and demand if the item were sold for $20. c....
-
1. Given = 2i j +3k, complete the following table ||0|| al = =
-
Reconsider the situation described in Problem 4. Assume that rather than annual deposits, she makes monthly deposits. The first deposit will be 1 month from today, and the last deposit will be 40...
-
The divestiture technique that Lee is recommending is most likely: A. a spin-off. B. a split-off. C. an equity carve-out. Mark Zin and Stella Lee are CEO and CFO, respectively, of Moonbase...
-
Show that the parity operator \(\Pi\) is its own inverse and is hermitian, so it is unitary.
-
Match the phrases in Column A with the corresponding dividend theory in Column B. Note that you may use the answers in Column B more than once. Column A 1. Bird in the hand 2. Homemade dividends 3....
-
Which policy of the Statement of Corporate Governance is least likely to ensure effective contributions from the board of directors? A. Policy #1. B. Policy #2. C. Policy #3. Mark Zin and Stella Lee...
-
5. Which is the right answer to the following? A directed graph has three points in it. It has three nodes (A, B, C) and three edges such that there is an edge between A and B, A and C, B and C. You...
-
Do animals have rights? If so, what are they? What duties do human beings have toward animals? Does KFC protect animal welfare at an acceptable level?
-
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...
-
What uses of the word reserve might be found in practice in various parts of the world?
-
In most countries, interest expense is: A. Taxable. B. Not tax-deductible. C. Tax-deductible. D. Not relevant for tax.
-
Under which countrys national accounting system is there the closest link between accounting and tax? A. Norway. B. Denmark. C. Germany. D. The UK.
Study smarter with the SolutionInn App