Skip to main content

DROP VIEW

Drop the view.

Syntax

DROP VIEW [ IF EXISTS ] [ <database_name>. ]view_name

Examples

DROP VIEW IF EXISTS tmp_view;

SELECT * FROM tmp_view;
ERROR 1105 (HY000): Code: 1025, Text = Unknown table 'tmp_view'.
Explore Databend Cloud for FREE
Low-cost
Fast Analytics
Easy Data Ingestion
Elastic Scaling
Try it today