---
title: remove_retention_policy() | Tiger Data Docs
description: Remove a retention policy from a hypertable
---

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

Remove a policy to drop chunks of a particular hypertable.

## Samples

```
SELECT remove_retention_policy('conditions');
```

Removes the existing data retention policy for the `conditions` table.

## Arguments

The syntax is:

```
SELECT remove_retention_policy(
    relation = '<hypertable_or_cagg_name>',
    if_exists = true | false
);
```

| Name        | Type     | Default | Required | Description                                                                    |
| ----------- | -------- | ------- | -------- | ------------------------------------------------------------------------------ |
| `relation`  | REGCLASS | -       | ✔        | Name of the hypertable or continuous aggregate from which to remove the policy |
| `if_exists` | BOOLEAN  | `false` | -        | Set to true to avoid throwing an error if the policy does not exist.           |

## Returns

This function returns void.