---
title: remove_continuous_aggregate_policy() | Tiger Data Docs
description: Remove a refresh policy from a continuous aggregate
---

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

Remove all refresh policies from a continuous aggregate.

```
remove_continuous_aggregate_policy(
    continuous_aggregate REGCLASS,
    if_exists BOOL = NULL
) RETURNS VOID
```

Note

To view the existing continuous aggregate policies, see the [policies informational view](/docs/reference/timescaledb/informational-views/policies/index.md).

## Samples

Remove all refresh policies from the `cpu_view` continuous aggregate:

```
SELECT remove_continuous_aggregate_policy('cpu_view');
```

## Arguments

The syntax is:

```
SELECT remove_continuous_aggregate_policy(
    continuous_aggregate = '<view_name>',
    if_exists = true | false
);
```

| Name                                   | Type       | Default | Required | Description                                                                                              |
| -------------------------------------- | ---------- | ------- | -------- | -------------------------------------------------------------------------------------------------------- |
| `continuous_aggregate`                 | `REGCLASS` | -       | ✔        | Name of the continuous aggregate the policies should be removed from                                     |
| `if_exists` (formerly `if_not_exists`) | `BOOL`     | false   | -        | When true, prints a warning instead of erroring if the policy doesn’t exist. Renamed in TimescaleDB 2.8. |

## Returns

This function returns void.