---
title: "Recover deleted table"
method: POST
path: "/table/recover/{table_id}"
tags: ["Tables"]
---

# Recover deleted table

`POST /table/recover/{table_id}`

Recovers a deleted table. If the parent database is also deleted, with proper permissions it will be recovered automatically.

## Path parameters

- `table_id` integer, required

## Request body

- object
  - `table_name` Name — unresolved $ref
  - `database_name` Name — unresolved $ref

## Response `200`

OK

- RecoveredTable — Recovered table; call GET /table/show/{database}/{table} for full details including schema
  - `id` integer, required
  - `name` Name, required — unresolved $ref
  - `count` Count, required — unresolved $ref
  - `counter_updated_at` CounterUpdatedAt, required — unresolved $ref
  - `created_at` CreatedAt, required — unresolved $ref
  - `updated_at` UpdatedAt, required — unresolved $ref
  - `estimated_storage_size` EstimatedStorageSize, required — unresolved $ref
  - `expire_days` ExpireDays, required — unresolved $ref
  - `include_v` IncludeV, required — unresolved $ref
  - `last_log_timestamp` LastLogTimestamp, required — unresolved $ref
  - `delete_protected` DeleteProtected, required — unresolved $ref
  - `type` Type, required — unresolved $ref

## Other responses

- `4XX` — Client Error
- `5XX` — Server Error

---

[API](https://skmtc.net/treasure/apis/treasure-data-api.md) · [All operations](https://skmtc.net/treasure/apis/treasure-data-api/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/treasure/treasure-data-api/revisions/a753ea35d9dd/schema)