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;