How to use the DROPVIEW statement to delete a PolarDB-X view-PolarDB(PolarDB)-阿里云帮助中心

Removes a view from a PolarDB-X instance. Dropping a view does not affect the underlying tables.

Syntax

DROP VIEW [IF EXISTS] view_name

Parameter	Description
`IF EXISTS`	Optional. Suppresses an error if the view does not exist. Without this clause, dropping a non-existent view returns an error.
`view_name`	The name of the view to drop.

The following example creates a view and then drops it. The underlying table data is not affected.

-- Create a view.
create view v as select 1;
-- Drop the view.
drop view v;