DROP VIEW

Description

This statement is used to delete a logical view VIEW Grammar: DROP VIEW [IF EXISTS] [db_name.]view_name;

example

  1. If it exists, delete view example_view on example_db DROP VIEW IF EXISTS example_db.example_view;

keyword

DROP,VIEW