> ## 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.
# SHOW SAVEPOINT STATUS
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
{children}
;
};
The `SHOW SAVEPOINT STATUS` statement lists the active savepoints in the current transaction.
## Required privileges
No privileges are required to create or show a savepoint. However, privileges are required for each statement within a transaction.
## Synopsis
## Response
The following fields are returned for each savepoint.
| Field | Description |
| ---------------------- | -------------------------------------------------------------------- |
| `savepoint_name` | The name of the savepoint. |
| `is_initial_savepoint` | Whether the savepoint is the outermost savepoint in the transaction. |
## Example
1. Open a transaction using `BEGIN`, and create a nested transaction using a savepoint:
```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
> BEGIN;
SAVEPOINT foo;
```
2. Use the `SHOW SAVEPOINT STATUS` statement to list the active savepoints in the current nested transaction.
```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
> SHOW SAVEPOINT STATUS;
```
```
savepoint_name | is_initial_savepoint
-----------------+-----------------------
foo | true
(1 row)
```
Currently, there is only one savepoint.
3. Commit this nested transaction by issuing the `RELEASE SAVEPOINT` statement, then clear the connection for the next transaction by issuing a `COMMIT` statement:
```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
> RELEASE SAVEPOINT foo;
COMMIT;
```
If we did not want to commit this nested transaction, but restart it instead, we would have issued a `ROLLBACK TO SAVEPOINT`.
## See also
* `SAVEPOINT`
* `RELEASE SAVEPOINT`
* `ROLLBACK`
* `BEGIN`
* `COMMIT`
* Transactions