That's it! It's time to wrap things up with a short review.

1. To delete a view, use:

   DROP VIEW big_gyms_london;

2. To delete a view and its dependencies, use:

   DROP VIEW big_gyms_london CASCADE;

3. To delete a table and its dependencies, use:

   DROP TABLE gym CASCADE;

4. To provide a new definition for an existing view in PostgreSQL, you can use:

   CREATE OR REPLACE VIEW big_gyms_london AS
   SELECT ...

All right, how about a short quiz now?