> ## 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](/docs/stable/sql-statements.md) resets a [session variable](/docs/stable/set-vars.md) to its default value for the client session.

## Required privileges

No [privileges](/docs/stable/security-reference/authorization.md#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](/docs/stable/set-vars.md#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)
```

## Known limitations

* `SET`  [`SET`](/docs/stable/set-vars)  and  `RESET`  [`RESET`](/docs/stable/reset-vars)  do not properly apply [`ROLLBACK`](/docs/stable/rollback-transaction) within a transaction. For example:

  ```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
  SET TIME ZONE +2;
  BEGIN;
  SET TIME ZONE +3;
  ROLLBACK;
  SHOW TIME ZONE;
  ```

  ```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
    timezone
  ------------
    <+03>-03
  ```

  ```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
  SET TIME ZONE +2;
  BEGIN;
  RESET TIME ZONE;
  ROLLBACK;
  SHOW TIME ZONE;
  ```

  ```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
    timezone
  ------------
    UTC
  ```

## See also

* [`SET {session variable}`](/docs/stable/set-vars)
* [`SHOW {session variable}`](/docs/stable/show-vars)
* [`SHOW DEFAULT SESSION VARIABLES FOR ROLE`](/docs/stable/show-default-session-variables-for-role)