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

# RESET CLUSTER SETTING

export const InternalLink = ({version, path = "", children, ...props}) => {
  let detectedVersion = version || "stable";
  if (typeof window !== 'undefined' && !version) {
    const match = window.location.pathname.match(/\/docs\/([^/]+)/);
    if (match) {
      detectedVersion = match[1];
    }
  }
  const normalizedPath = path.startsWith("/") ? path.slice(1) : path;
  return <a href={`/docs/${detectedVersion}/${normalizedPath}`} {...props}>
      {children}
    </a>;
};

The `RESET` <InternalLink path="sql-statements">statement</InternalLink> resets a <InternalLink path="set-cluster-setting">cluster setting</InternalLink> to its default value for the client session.

## Required privileges

Only members of the `admin` role can modify cluster settings. By default, the `root` user belongs to the `admin` role.

## Synopsis

<img src="https://mintcdn.com/cockroachlabs/Bc-7BE4092mn9J_1/images/sql-diagrams/v23.2/reset_csetting.svg?fit=max&auto=format&n=Bc-7BE4092mn9J_1&q=85&s=4f02544687535504f203f5b2090da5b1" alt="reset_csetting syntax diagram" style={{maxWidth: "100%", overflowX: "auto"}} width="427" height="37" data-path="images/sql-diagrams/v23.2/reset_csetting.svg" />

## Parameters

| Parameter   | Description                                                                                              |
| ----------- | -------------------------------------------------------------------------------------------------------- |
| `var\_name` | The name of the <InternalLink path="cluster-settings">cluster setting</InternalLink> (case-insensitive). |

## Example

You can use <InternalLink path="set-cluster-setting">`SET CLUSTER SETTING.. TO DEFAULT`</InternalLink> to reset a cluster setting as well.

```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
> SET CLUSTER SETTING sql.metrics.statement_details.enabled = false;
```

```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
> SHOW CLUSTER SETTING sql.metrics.statement_details.enabled;
```

```text theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
  sql.metrics.statement_details.enabled
-----------------------------------------
                  false
(1 row)
```

```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
> RESET CLUSTER SETTING sql.metrics.statement_details.enabled;
```

```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
> SHOW CLUSTER SETTING sql.metrics.statement_details.enabled;
```

```text theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
  sql.metrics.statement_details.enabled
-----------------------------------------
                  true
(1 row)
```

## See also

* <InternalLink path="set-cluster-setting">`SET CLUSTER SETTING`</InternalLink>
* <InternalLink path="show-cluster-setting">`SHOW CLUSTER SETTING`</InternalLink>
* <InternalLink path="cluster-settings">Cluster settings</InternalLink>
