# DROP VIEW

The `DROP VIEW` command drops a view.

## Syntax

```
DROP VIEW [IF EXISTS] <view_name>;

```

## Remarks

* `DROP VIEW` privileges are granted only to the user who created the view and to users with `SUPER` privileges.
* This command can be run on the master aggregator node, or a child aggregator node (see [Node Requirements for SingleStore Commands](https://docs.singlestore.com/db/v9.1/reference/sql-reference/cluster-management-commands.md) ).
* This command causes implicit commits. Refer to [COMMIT](https://docs.singlestore.com/db/v9.1/reference/sql-reference/data-manipulation-language-dml/commit.md) for more information.
* Refer to the [Permissions Matrix](https://docs.singlestore.com/db/v9.1/reference/sql-reference/security-management-commands/permissions-matrix.md) for the required permissions.

## Examples

```sql
DROP VIEW inventory_view;

```

```sql
DROP VIEW IF EXISTS inventory_view;
```

## Related Topics

* [ALTER VIEW](https://docs.singlestore.com/db/v9.1/reference/sql-reference/data-definition-language-ddl/alter-view.md)
* [CREATE VIEW](https://docs.singlestore.com/db/v9.1/reference/sql-reference/data-definition-language-ddl/create-view.md)

***

Modified at: June 11, 2026

Source: [/db/v9.1/reference/sql-reference/data-definition-language-ddl/drop-view/](https://docs.singlestore.com/db/v9.1/reference/sql-reference/data-definition-language-ddl/drop-view/)

(An index of the documentation is available at /llms.txt)