Deletes one or more views from the database.
Syntax
DROP VIEW [IF EXISTS] view_name [, view_name] ...Parameters
| Parameter | Description |
|---|---|
IF EXISTS | Suppresses an error if the specified view does not exist. Optional. |
view_name | The name of the view to delete. To reference a view in a specific database, use the database_name.view_name format. To delete multiple views in a single statement, specify their names as a comma-separated list. |
Example
Delete a view named v:
DROP VIEW v;