---
title: remove_columnstore_policy() | Tiger Data Docs
description: Remove a columnstore policy from a hypertable
---

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

`remove_columnstore_policy()` replaces `remove_compression_policy()`, deprecated in 2.18.0. The parameters are the same.

Remove a columnstore policy from a hypertable or continuous aggregate.

To restart automatic chunk migration to the columnstore, you need to call [add\_columnstore\_policy](/docs/reference/timescaledb/hypercore/add_columnstore_policy/index.md) again.

## Samples

You see the columnstore policies in the [informational views](/docs/reference/timescaledb/informational-views/jobs/index.md).

- **Remove the columnstore policy from the `cpu` table**:

  ```
  CALL remove_columnstore_policy('cpu');
  ```

- **Remove the columnstore policy from the `cpu_weekly` continuous aggregate**:

  ```
  CALL remove_columnstore_policy('cpu_weekly');
  ```

## Arguments

The syntax is:

```
CALL remove_columnstore_policy(
    hypertable = '<hypertable_name>',
    if_exists = true | false
);
```

| Name         | Type     | Default | Required | Description                                                                                                                |
| ------------ | -------- | ------- | -------- | -------------------------------------------------------------------------------------------------------------------------- |
| `hypertable` | REGCLASS | -       | ✔        | Name of the hypertable or continuous aggregate to remove the policy from                                                   |
| `if_exists`  | BOOLEAN  | `false` | ✖        | Set to `true` so this job fails with a warning rather than an error if a columnstore policy does not exist on `hypertable` |

## Returns

This function returns void.