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

Updatable views
Materialized views
7. Deleting materialized views
Summary

Instruction

So, the data was correct after we refreshed the materialized view.

Materialized views take up space in the database. When you no longer need them, you can delete them using this syntax:

DROP MATERIALIZED VIEW top100_universities;

The query above will remove the materialized view top100_universities and free the space it previously occupied.

Exercise

Once again we've created the product table and the available_dairy_products view. Remove the available_dairy_products view.

Stuck? Here's a hint!

Use:

DROP MATERIALIZED VIEW ...;