Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

Working with Views

Deleting views
Deleting and modifying tables with views
5. Deleting tables with views – 1
Modifying views
Summary

Instruction

Now, what happens if we try to delete a table that has some dependent views? Will this code work?

DROP TABLE gym;

Let's find out.

Exercise

We've prepared the gym table and a view dependent on it (big_gyms_london). Run the template code, which attempts to drop the table.