DROP VIEW

Drop a view.

DROP VIEW removes a VIEW. Table data is not affected.

DROP VIEW active_customers;

This query removes the VIEW.

DROP VIEW — details

DROP VIEW only deletes the definition. Underlying tables and data remain.

Instead of dropping and recreating a view to change it, you can also use CREATE OR REPLACE VIEW.

Remove the active_customers VIEW with DROP VIEW.

Show example solution

DROP VIEW active_customers;

Add DROP VIEW

DROP ____ active_customers;

Show answer

DROP VIEW active_customers;