---
title: DROP MATERIALIZED VIEW (continuous aggregate) | Tiger Data Docs
description: Drop a continuous aggregate view
---

Since [1.3.0](https://github.com/timescale/timescaledb/releases/tag/1.3.0)

Continuous aggregate views can be dropped using the `DROP MATERIALIZED VIEW` statement.

This statement deletes the continuous aggregate and all its internal objects. It also removes refresh policies for that aggregate. To delete other dependent objects, such as a view defined on the continuous aggregate, add the `CASCADE` option. Dropping a continuous aggregate does not affect the data in the underlying hypertable from which the continuous aggregate is derived.

```
DROP MATERIALIZED VIEW <view_name>;
```

## Samples

Drop existing continuous aggregate.

```
DROP MATERIALIZED VIEW contagg_view;
```

## Arguments

The syntax is:

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

| Name          | Type | Default | Required | Description                                                                    |
| ------------- | ---- | ------- | -------- | ------------------------------------------------------------------------------ |
| `<view_name>` | TEXT | -       | ✔        | Name (optionally schema-qualified) of continuous aggregate view to be dropped. |

## Returns

For standard `DROP MATERIALIZED VIEW` return behavior, see the [PostgreSQL DROP MATERIALIZED VIEW documentation](https://www.postgresql.org/docs/current/sql-dropmaterializedview.html).