This topic describes how to use the DROP VIEW statement to delete a view of a DRDS instance.

Prerequisites

The version of the DRDS 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;