docs-v2/content/shared/influxdb3-admin/last-value-cache/delete.md

Use the influxdb3 delete last_cache command to delete a Last Value Cache (LVC). Provide the following:

• Database (-d, --database): ({{< req >}}) The name of the database that the LVC you want to delete is associated with. You can also use the INFLUXDB3_DATABASE_NAME environment variable to specify the database.
• Token (--token): ({{< req >}}) Your {{< product-name >}} {{% show-in "enterprise" %}}admin {{% /show-in %}}authentication token. You can also use the INFLUXDB3_AUTH_TOKEN environment variable to specify the database.
• Table (-t, --table): ({{< req >}}) The name of the table that the LVC you want to delete is associated with.
• Cache name: The name of the LVC to delete.

{{% code-placeholders "(DATABASE|TABLE|LVC)_NAME|AUTH_TOKEN" %}}

influxdb3 delete last_cache \
  --database DATABASE_NAME \
  --token AUTH_TOKEN \
  --table TABLE_NAME \
  LVC_NAME

{{% /code-placeholders %}}

Use the HTTP API

To use the HTTP API to delete a Last Value Cache, send a DELETE request to the /api/v3/configure/last_cache endpoint with query parameters.

{{% api-endpoint method="DELETE" endpoint="/api/v3/configure/last_cache" api-ref="/influxdb3/core/api/v3/#operation/DeleteConfigureLastCache" %}}

{{% code-placeholders "(DATABASE|TABLE|LVC)_NAME|AUTH_TOKEN" %}}

curl -X DELETE "https://localhost:8181/api/v3/configure/last_cache?db=DATABASE_NAME&table=TABLE_NAME&name=LVC_NAME" \
  --header "Authorization: Bearer AUTH_TOKEN"

{{% /code-placeholders %}}

Example

curl -X DELETE "https://localhost:8181/api/v3/configure/last_cache?db=example-db&table=home&name=homeLastCache" \
  --header "Authorization: Bearer 00xoXX0xXXx0000XxxxXx0Xx0xx0"

Response codes:

• 200 : Success. The last cache has been deleted.
• 400 : Bad request.
• 401 : Unauthorized.
• 404 : Cache not found.

Replace the following:

• {{% code-placeholder-key %}}DATABASE_NAME{{% /code-placeholder-key %}}: the name of the database that the LVC you want to delete is associated with
• {{% code-placeholder-key %}}AUTH_TOKEN{{% /code-placeholder-key %}}: your {{< product-name >}} {{% show-in "enterprise" %}}admin {{% /show-in %}} authentication token
• {{% code-placeholder-key %}}TABLE_NAME{{% /code-placeholder-key %}}: the name of the table that the LVC you want to delete is associated with
• {{% code-placeholder-key %}}LVC{{% /code-placeholder-key %}}: the name of the LVC to delete

[!Caution] This is a destructive action that cannot be undone. Once deleted, any queries against the deleted LVC will return an error.