# DROP PITR

## Syntax Description

`DROP PITR` is used to delete the pitr created under the current instance.

## Syntax Structure

```sql
DROP PITR pitr_name;
```

## Example

```text
create pitr db_pitr1 for database db1 range 1 'y';

mysql> show pitr where pitr_name='db_pitr1';
+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
| pitr_name | created_time | modified_time | pitr_level | account_name | database_name | table_name | pitr_length | pitr_unit |
+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
| db_pitr1 | 2024-12-17 03:14:06 | 2024-12-17 03:14:06 | database | 0193ba05-6cd6-7bca-ba0b-60828b25xxxx | db1 | * | 1 | y |
+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
1 row in set (0.11 sec)

mysql> drop pitr db_pitr1;
Query OK, 0 rows affected (0.01 sec)

mysql> show pitr where pitr_name='db_pitr1';
Empty set (0.01 sec)
```