# 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 [#user](https://docs.deltastream.io/overview/core-concepts/access-control#user "mention") in the current [#organiation](https://docs.deltastream.io/overview/core-concepts/access-control#organiation "mention").

### 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 |
+----------+------------+-------------------------------+-------------------------------+
```