Answer-first summary for fast verification
Answer: DROP DATABASE customers CASCADE
The correct command is `DROP DATABASE customers CASCADE`. This command efficiently removes the database and all its managed tables in one step, without the need for additional cleanup, as all tables within are managed.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
To delete the 'customers' database along with all its managed tables and associated data, which SQL command should you use?
A
DROP DATABASE customers INCLUDE
B
All the tables must be dropped first before dropping the database
C
DROP DATABASE customers FORCE
D
DROP DATABASE customers CASCADE
E
DROP DELTA DATABASE customers
No comments yet.