Which of the following is true of the 'DROP TABLE' statement in SQL? Deletes the table structure only Deletes the table structure along with the table Works whether or not referential integrity constraints would be violated It’s not a sql statement
Added by Bwa T.
Step 1
Deletes the table structure only: This is not entirely true. The 'DROP TABLE' statement in SQL does delete the table structure, but it also deletes all the data within the table. Show more…
Show all steps
Close
Your feedback will help us improve your experience
Breanna Ollech and 60 other Algebra and Trigonometry educators are ready to help you.
Ask a new question
Labs
Want to see this concept in action?
Explore this concept interactively to see how it behaves as you change inputs.
Key Concepts
Recommended Videos
'Which SQL Command is used to delete a table from the database: a) Update b) Alter c) Drop d) Select'
Sarvesh S.
Paul G.
Which of the following SQL statements contains an error? I) Select * from employee; II) Select * from employee where employeeid = 165; III) Select employeeid from employee where employeeid = 108 and lastname = NAIK; IV) None
Recommended Textbooks
Introductory and Intermediate Algebra for College Students 4th
Prealgebra
Prealgebra and Introductory Algebra
Transcript
Watch the video solution with this free unlock.
EMAIL
PASSWORD