DROP VIEW
Function
DROP VIEW deletes an existing view.
Precautions
Only a view owner or a system administrator can run DROP VIEW command.
- Be cautious when using DROP OBJECT (e.g., DATABASE, USER/ROLE, SCHEMA, TABLE, VIEW) as it may cause data loss, especially with CASCADE deletions. Always back up data before proceeding.
- For more information about development and design specifications, see Development and Design Proposal.
Syntax
1 | DROP VIEW [ IF EXISTS ] view_name [, ...] [ CASCADE | RESTRICT ]; |
Parameter Description
| Parameter | Description | Value Range |
|---|---|---|
| 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. | An existing view. |
| CASCADE | RESTRICT | Specifies the policy for processing dependent objects when an existing view is deleted.
| - |
Examples
Delete the view myView.
1 | DROP VIEW IF EXISTS myView; |
Delete the view customer_details_view_v2.
1 | DROP VIEW IF EXISTS public.customer_details_view_v2; |