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

# RESET {session variable}

The `RESET` [statement](https://docs.cockroachlabs.com/docs/v24.2/sql-statements) resets a [session variable](https://docs.cockroachlabs.com/docs/v24.2/set-vars) to its default value for the client session.

## Required privileges

No [privileges](https://docs.cockroachlabs.com/docs/v24.2/security-reference/authorization#managing-privileges) are required to reset a session setting.

## Synopsis

![reset\_session syntax diagram](https://mintcdn.com/cockroachlabs/UZNSFbmU2EwEm6G5/images/sql-diagrams/common/reset_session.svg?fit=max\&auto=format\&n=UZNSFbmU2EwEm6G5\&q=85\&s=9c3649e9006c09fc99b572ad56a3fea8)

## Parameters

| Parameter | Description |
| - | - |
| `session_var` | The name of the [session variable](https://docs.cockroachlabs.com/docs/v24.2/set-vars#supported-variables). |

## Example

```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;
```

```
 extra_float_digits
--------------------
 -10
(1 row)
```

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

```
 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;
```

```
 extra_float_digits
--------------------
 0
(1 row)
```

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

```
      random
-------------------
 0.561354028296755
(1 row)
```

## See also

* [`SET {session variable}`](https://docs.cockroachlabs.com/docs/v24.2/set-vars)
* [`SHOW {session variable}`](https://docs.cockroachlabs.com/docs/v24.2/show-vars)
* [`SHOW DEFAULT SESSION VARIABLES FOR ROLE`](https://docs.cockroachlabs.com/docs/v24.2/show-default-session-variables-for-role)