Drops an existing view from MaxCompute.
Syntax
DROP VIEW [IF EXISTS] <view_name>;Parameters
| Parameter | Required | Description |
|---|---|---|
IF EXISTS | No | Suppresses the error if the view does not exist. Without this clause, an error is returned when the specified view is not found. |
view_name | Yes | The name of the view to drop. |
Example
-- Drop the sale_detail_view view.
DROP VIEW IF EXISTS sale_detail_view;What's next
- CREATE VIEW: Creates a view or updates an existing view based on a query statement.
- ALTER VIEW: Renames an existing view or changes the owner of an existing view.
- DESC VIEW: Views the information of an existing view.