Release History
Help

YMatrix

Quick Start

Deployment

Data Usage

Manage Clusters

Security

Best Practice

Technical Principles

Advanced Features

Guide

SQL Reference

FAQ

DROP VIEW

Delete the view.

Synopsis

DROP VIEW [IF EXISTS] name [, ...] [CASCADE | RESTRICT]

Description

DROP VIEW will delete the existing view. Only view owners can delete it.

Parameters

IF EXISTS

  • If the view does not exist, please do not report an error. In this case, a notification will be issued.

name

  • The name of the view to be deleted (can be specified by the pattern).

CASCADE

  • Automatically delete views-dependent objects (such as other views).

RESTRICT

  • If any object depends on the view, the view is denied. This is the default value.

Example

Delete the view topten:

DROP VIEW topten;

Compatibility

DROP VIEW is fully SQL-compliant, but this standard allows only one view per command to be deleted. Additionally, the IF EXISTS option is a YMatrix database extension.

See also

ALTER VIEW , CREATE VIEW

← Previous
DROP_USER_MAPPING
Next →
END