> For the complete documentation index, see [llms.txt](https://docs.deltastream.io/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.deltastream.io/reference/sql-syntax/ddl/alter-api_token.md).

# ALTER API\_TOKEN

## Syntax <a href="#synopsis" id="synopsis"></a>

```sql
ALTER API_TOKEN api_token_name RENEW TOKEN;
```

## Description <a href="#description" id="description"></a>

Modify an existing `API_TOKEN` for a [Access Control](/overview/core-concepts/access-control.md#user) in the current [Access Control](/overview/core-concepts/access-control.md#organiation).

### Arguments

#### api\_token\_name

This specifies the name of the `API_TOKEN` to modify.

## Examples <a href="#example" id="example"></a>

#### Refresh an existing API\_TOKEN

This example shows an existing API token `my_token` getting renewed:

```shell
<no-db>/<no-store># LIST API_TOKENS;
+----------+-------------------------------+-------------------------------+-------------------------------+
|  Name    |  Last Used                    |  Created At                   |  Expires At                   |
+==========+===============================+===============================+===============================+
| my_token | 2024-07-11 20:38:32 +0000 UTC | 2024-07-11 20:37:17 +0000 UTC | 2024-10-09 20:37:17 +0000 UTC |
+----------+-------------------------------+-------------------------------+-------------------------------+
<no-db>/<no-store># ALTER API_TOKEN my_token RENEW TOKEN;
+-----------+----------+----------+------------------------------------------+--------------------------------+
|  Type     |  Name    |  Command |  Summary                                 |  Token                         |
+===========+==========+==========+==========================================+================================+
| api_token | my_token | ALTER    | api_token my_token was successfully      | <redacted_refreshed_api_token> |
|           |          |          | refreshed                                |                                |
+-----------+----------+----------+------------------------------------------+--------------------------------+
```

Note how the creation and expiration time of the API token changes and last used time resets after the `ALTER` statement successfully executes:

```bash
<no-db>/<no-store># LIST API_TOKENS;
+----------+------------+-------------------------------+-------------------------------+
|  Name    |  Last Used |  Created At                   |  Expires At                   |
+==========+============+===============================+===============================+
| my_token | <null>     | 2024-07-11 20:38:50 +0000 UTC | 2024-10-09 20:38:50 +0000 UTC |
+----------+------------+-------------------------------+-------------------------------+
```