On this page 
Warning:
CockroachDB v2.0 is no longer supported as of October 4, 2019. For more details, refer to the Release Support Policy.
The RESET statement resets a session variable to its default value for the client session.
Required Privileges
No privileges are required to reset a session setting.
Synopsis
Parameters
| Parameter | Description |
|---|---|
session_var |
The name of the session variable. |
Example
Tip:
You can use SET .. TO DEFAULT to reset a session variable as well.> SET default_transaction_isolation = SNAPSHOT;
> SHOW default_transaction_isolation;
+-------------------------------+
| default_transaction_isolation |
+-------------------------------+
| SNAPSHOT |
+-------------------------------+
(1 row)
> RESET default_transaction_isolation;
> SHOW default_transaction_isolation;
+-------------------------------+
| default_transaction_isolation |
+-------------------------------+
| SERIALIZABLE |
+-------------------------------+
(1 row)
See Also
Was this helpful?
