> ## 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 {session variable}

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-vars">session variable</InternalLink> to its default value for the client session.

## Required privileges

No <InternalLink path="security-reference/authorization#managing-privileges">privileges</InternalLink> are required to reset a session setting.

## Synopsis

<img src="https://mintcdn.com/cockroachlabs/kYb5CU8_1XGPxWhU/images/sql-diagrams/v24.1/reset_session.svg?fit=max&auto=format&n=kYb5CU8_1XGPxWhU&q=85&s=034d54039813867c48f4d5fea2b715c9" alt="reset_session syntax diagram" style={{maxWidth: "100%", overflowX: "auto"}} width="419" height="113" data-path="images/sql-diagrams/v24.1/reset_session.svg" />

## Parameters

| Parameter      | Description                                                                                        |
| -------------- | -------------------------------------------------------------------------------------------------- |
| `session\_var` | The name of the <InternalLink path="set-vars#supported-variables">session variable</InternalLink>. |

## Example

You can use <InternalLink path="set-vars#reset-a-variable-to-its-default-value">`SET.. TO DEFAULT`</InternalLink> to reset a session variable as well.

```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
> SET extra_float_digits = -10;
```

```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
> SHOW extra_float_digits;
```

```text theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
 extra_float_digits
--------------------
 -10
(1 row)
```

```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
> SELECT random();
```

```text theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
 random
---------
 0.20286
(1 row)
```

```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
> RESET extra_float_digits;
```

```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
> SHOW extra_float_digits;
```

```text theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
 extra_float_digits
--------------------
 0
(1 row)
```

```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
> SELECT random();
```

```text theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
      random
-------------------
 0.561354028296755
(1 row)
```

## See also

* <InternalLink path="set-vars">`SET session variable`</InternalLink>
* <InternalLink path="show-vars">`SHOW session variable`</InternalLink>
* <InternalLink path="show-default-session-variables-for-role">`SHOW DEFAULT SESSION VARIABLES FOR ROLE`</InternalLink>
