# Recover Table

+ Suitable for drop actions
  + `RECOVER TABLE table_name;` 

------------------------------------------------------------

- Recover deleted tables based on table name
Find the first drop table in the DDL JOB history to recover, and the table name of the dropped table must be exactly the same as the table in the recover:
```
RECOVER TABLE table_name 
```

- Recover a drop table based on the DDL JOB ID when the table was deleted
1. Confirm DDL Job ID
```
admin show ddl jobs;
```

2. Recover table
```
RECOVER TABLE BY JOB ddl_job_id
```