This topic describes how to use the DROP VIEW statement to delete a view of a PolarDB-X 1.0 instance.
Prerequisites
The version of the PolarDB-X 1.0 instance must be 5.4.5 or later.
Syntax
DROP VIEW [IF EXISTS] view_name
Examples
# Create a view: create view v as select 1;
# Delete a view: drop view v;