---
title: "PURGE - OceanBase 数据库 V4.2.0 | OceanBase 文档中心"
description: "PURGE 描述 该语句用于删除回收站中的数据库对象，只支持删除租户、数据库、表与索引。 语法 PURGE {TENANT | DATABASE | TABLE | INDEX} object_name; object_name: tenant_name | database_name | table_name | …"
---
切换语言

- 中文站 - 简体中文
- International - English
- 日本站 - 日本語

文档反馈![](https://mdn.alipayobjects.com/huamei_22khvb/afts/img/A*P8CuR4UJ_FkAAAAAAAAAAAAADiGDAQ/original) OceanBase 数据库分布式版 - V 4.2.0

# PURGE

更新时间：2023-08-01 14:14:04

[编辑](https://github.com/oceanbase/oceanbase-doc/edit/V4.2.0/zh-CN/700.reference/500.sql-reference/100.sql-syntax/200.common-tenant-of-mysql-mode/600.sql-statement-of-mysql-mode/7200.purge-database-of-mysql-mode.md)  

## 描述

该语句用于删除回收站中的数据库对象，只支持删除租户、数据库、表与索引。

## 语法

```sql
 PURGE {TENANT | DATABASE | TABLE | INDEX} object_name;

object_name:
    tenant_name
  | database_name
  | table_name
  | index_name

```

## 参数解释

| **参数** | **描述** |
| --- | --- |
| tenant_name | 指定要删除的租户名称。 可以使用删除前的原始租户名，也可以使用在回收站中的名字。回收站中的名字具有唯一性，可以指定确定的租户；原始租户名可能会重复，此时删除的是最早进入回收站的租户。 |
| database_name | 指定要删除的数据库在回收站中的名称，不支持直接指定数据库的名称。 |
| table_name | 指定要删除的表在回收站中的名称，不支持直接指定表的名称。 |
| index_name | 指定要删除的索引在回收站中的名称，不支持直接指定索引的名称。 |

## 示例

- 删除回收站中的租户 `mysql`。

  ```sql
  obclient> SHOW RECYCLEBIN;
  +--------------------------------+---------------+--------+----------------------------+
  | OBJECT_NAME                    | ORIGINAL_NAME | TYPE   | CREATETIME                 |
  +--------------------------------+---------------+--------+----------------------------+
  | __recycle_$_1_1599722585571328 | mysql         | TENANT | 2020-09-10 15:36:54.712101 |
  +--------------------------------+---------------+--------+----------------------------+
  1 row in set

  obclient> PURGE TENANT mysql;
  Query OK, 0 rows affected

  obclient> SHOW RECYCLEBIN;
  Empty set

  ```
 - 删除回收站中的数据库 `__recycle_$_1_1597384386029184`。

  ```sql
  obclient> CREATE DATABASE db1;
  Query OK, 1 row affected

  obclient> DROP DATABASE db1;
  Query OK, 0 rows affected

  obclient> SHOW RECYCLEBIN;
  +--------------------------------+---------------+----------+----------------------------+
  | OBJECT_NAME                    | ORIGINAL_NAME | TYPE     | CREATETIME                 |
  +--------------------------------+---------------+----------+----------------------------+
  | __recycle_$_1_1597384386029184 | db1           | DATABASE | 2020-08-14 13:53:06.029367 |
  +--------------------------------+---------------+----------+----------------------------+
  1 row in set

  obclient> PURGE DATABASE __recycle_$_1_1597384386029184;
  Query OK, 0 rows affected

  ```
 - 删除回收站中的表 `__recycle_$_1_1099511628776_1099511677778`。

  ```sql
  obclient> CREATE TABLE test(c1 INT);
  Query OK, 0 rows affected

  obclient> DROP TABLE test;
  Query OK, 0 rows affected

  obclient> SHOW RECYCLEBIN;
  +-------------------------------------------+---------------+-------+----------------------------+
  | OBJECT_NAME                               | ORIGINAL_NAME | TYPE  | CREATETIME                 |
  +-------------------------------------------+---------------+-------+----------------------------+
  | __recycle_$_1_1099511628776_1099511677778 | test          | TABLE | 2017-10-20 17:40:22.304025 |
  +-------------------------------------------+---------------+-------+----------------------------+
  1 row in set

  obclient> PURGE TABLE __recycle_$_1_1099511628776_1099511677778;
  Query OK, 0 rows affected

  ```
 - 删除回收站中的索引 `__recycle_$_1_1597387726700872`。

  ```sql
  obclient> CREATE TABLE t1(c1 INT);
  Query OK, 0 rows affected

  obclient> CREATE INDEX idx ON t1(c1);
  Query OK, 0 rows affected

  obclient> DROP TABLE t1;
  Query OK, 0 rows affected

  obclient> SHOW RECYCLEBIN;
  +--------------------------------+----------------------------+-------+----------------------------+
  | OBJECT_NAME                    | ORIGINAL_NAME              | TYPE  | CREATETIME                 |
  +--------------------------------+----------------------------+-------+----------------------------+
  | __recycle_$_1_1597387726700872 | __idx_1101710651081557_idx | INDEX | 2020-08-14 14:48:46.699145 |
  | __recycle_$_1_1597387726712976 | t1                         | TABLE | 2020-08-14 14:48:46.712643 |
  +--------------------------------+----------------------------+-------+----------------------------+
  2 rows in set

  obclient> PURGE INDEX __recycle_$_1_1597387726700872;
  Query OK, 0 rows affected

  obclient> SHOW RECYCLEBIN;
  +--------------------------------+----------------------------+-------+----------------------------+
  | OBJECT_NAME                    | ORIGINAL_NAME              | TYPE  | CREATETIME                 |
  +--------------------------------+----------------------------+-------+----------------------------+
  | __recycle_$_1_1597387726700872 | __idx_1101710651081557_idx | INDEX | 2020-08-14 14:48:46.699145 |
  +--------------------------------+----------------------------+-------+----------------------------+
  1 rows in set

  ```

 上一篇 下一篇 ![有帮助](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*y6ocSqN8cqsAAAAAAAAAAAAAARQnAQ)![无帮助](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*BG9IQJyLHF8AAAAAAAAAAAAAARQnAQ)![反馈](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*eTWdQKCRKHwAAAAAAAAAAAAAARQnAQ)[AI](https://www.oceanbase.com/obi) 咨询热线