content/shared/influxdb3-cli/update/table/_index.md
The influxdb3 update table command updates an existing table in a database in your {{< product-name >}} instance.
Use this command to update a table's retention period.
influxdb3 update table [OPTIONS] --database <DATABASE_NAME> <TABLE_NAME>
TABLE_NAME: (Required) The name of the table to update| Option | Description | |
|---|---|---|
-H | --host | Host URL of the running {{< product-name >}} server (default is http://127.0.0.1:8181) |
-d | --database | The name of the database containing the table |
--token | Authentication token | |
-r | --retention-period | The retention period as a duration value (for example: 30d, 24h) or none to clear |
--tls-ca | Path to a custom TLS certificate authority (for testing or self-signed certificates) | |
--tls-no-verify | Disable TLS certificate verification (Not recommended in production, useful for self-signed certificates) | |
-h | --help | Print help information |
--help-all | Print detailed help information |
You can use the following environment variables instead of providing CLI options directly:
| Environment Variable | Option |
|---|---|
INFLUXDB3_HOST_URL | --host |
INFLUXDB3_DATABASE_NAME | --database |
INFLUXDB3_AUTH_TOKEN | --token |
INFLUXDB3_TLS_CA | --tls-ca |
INFLUXDB3_TLS_NO_VERIFY | --tls-no-verify |
The following examples show how to update a table.
In your commands replace the following:
DATABASE_NAME{{% /code-placeholder-key %}}:
Database nameTABLE_NAME{{% /code-placeholder-key %}}:
Table nameAUTH_TOKEN{{% /code-placeholder-key %}}:
Authentication token{{% code-placeholders "DATABASE_NAME|TABLE_NAME|AUTH_TOKEN" %}}
Updates a table retention period to 30 days.
<!--pytest.mark.skip-->influxdb3 update table --database DATABASE_NAME --token AUTH_TOKEN --retention-period 30d TABLE_NAME
Removes the retention period from a table by setting it to none.
influxdb3 update table --database DATABASE_NAME --retention-period none TABLE_NAME
{{% /code-placeholders %}}