DROP VIEW
Descriptionβ
This statement is used to drop a logical view VIEW
Syntaxβ
DROP VIEW [IF EXISTS]
[db_name.]view_name
Examplesβ
-
If it exists, then drop the view example_view on example_db.
DROP VIEW IF EXISTS example_db.example_view;