# Recover deleted table

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

Endpoint: POST /table/recover/{table_id}
Version: 3
Security: ApiKeyAuth

## Path parameters:

  - `table_id` (integer, required)
    Example: 11

## Request fields (application/json):

  - `table_name` (string)
    Example: "Bravo"

  - `database_name` (string)
    database name
    Example: "Alpha"

## Response 200 fields (application/json):

  - `id` (integer, required)
    Example: 11

  - `name` (string, required)
    Example: "Bravo"

  - `count` (integer, required)
    Example: 1000

  - `counter_updated_at` (any, required)

  - `created_at` (string, required)
    Datetime in custom format (2020-12-31 11:22:33 -0500 or 2020-12-31 11:22:33 UTC for UTC)
    Example: "2020-12-31 11:22:33 UTC"

  - `updated_at` (string, required)
    Datetime in custom format (2020-12-31 11:22:33 -0500 or 2020-12-31 11:22:33 UTC for UTC)
    Example: "2020-12-31 11:22:33 UTC"

  - `estimated_storage_size` (integer, required)
    Example: 1073741824

  - `expire_days` (integer,null, required)
    Example: 30

  - `last_log_timestamp` (integer,null, required)
    Example: 1356998400

  - `delete_protected` (boolean, required)
    Example: true

  - `type` (string, required)
    Enum: "log"

  - `include_v` (boolean, required)
    when true, Hive queries can access a virtual column "v" which contains a map of every data column's name to its value (represented as a string). Prefer to set a schema on the table instead of using "v".


## Response 4XX fields

## Response 5XX fields