> ## Documentation Index
> Fetch the complete documentation index at: https://mintlify-poc.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# remove_reorder_policy()

> Remove a reorder policy from a hypertable

export const CHUNK_CAP = 'Chunk';

export const CHUNK = 'chunk';

export const HYPERTABLE_CAP = 'Hypertable';

export const HYPERTABLE = 'hypertable';

<Tag>Community</Tag>

<Icon icon="tag" iconType="duotone" /> Since [1.2.0][tsdb-1.2.0]

Remove a policy to reorder a particular {HYPERTABLE}.

## Samples

```sql theme={"dark"}
SELECT remove_reorder_policy('conditions', if_exists => true);
```

removes the existing reorder policy for the `conditions` table if it exists.

## Arguments

The syntax is:

```sql theme={"dark"}
SELECT remove_reorder_policy(
    hypertable = '<hypertable_name>',
    if_exists = true | false
);
```

| Name         | Type     | Default | Required | Description                                                                                               |
| ------------ | -------- | ------- | -------- | --------------------------------------------------------------------------------------------------------- |
| `hypertable` | REGCLASS | -       | ✔        | Name of the {HYPERTABLE} from which to remove the policy.                                                 |
| `if_exists`  | BOOLEAN  | `FALSE` | ✖        | Set to true to avoid throwing an error if the reorder\_policy does not exist. A notice is issued instead. |

## Returns

This function returns void.

[tsdb-1.2.0]: https://github.com/timescale/timescaledb/releases/tag/1.2.0