• Data Warehouse Service

dws
  1. Help Center
  2. Data Warehouse Service
  3. Developer Guide
  4. SQL Reference
  5. SQL Syntax
  6. DROP VIEW

DROP VIEW

Function

DROP VIEW forcibly deletes an existing view in a database.

Precautions

Only a view owner or a system administrator can run DROP VIEW command.

Syntax

DROP VIEW [ IF EXISTS ] view_name [, ...] [ CASCADE | RESTRICT ];

Parameter Description

  • IF EXISTS

    Sends a notice instead of an error if the specified view does not exist.

  • view_name

    Specifies the name of the view to be deleted.

    Value range: An existing view.

  • CASCADE | RESTRICT
    • CASCADE: deletes objects (such as other views) that depend on a view to be deleted.
    • RESTRICT: refuses to delete the view if any objects depend on it. This is the default.

Examples

See Examples in CREATE VIEW.

Helpful Links

ALTER VIEWCREATE VIEW