[TOC] # PURGE INDEX ## 描述 该语句用来删除放在回收站中的索引表。 ## 格式 ~~~ PURGE INDEX object_name; ~~~ ## 参数解释 <table data-tag="table" id="table-frp-aqs-5ft" class="table"><colgroup width="360" span="1" data-tag="col" id="col-gha-xnk-m0d" colwidth="1*" colnum="1" colname="col1" style="width:50%" class="col"></colgroup><colgroup width="360" span="1" data-tag="col" id="col-nnp-v3h-i7r" colwidth="1*" colnum="2" colname="col2" style="width:50%" class="col"></colgroup><thead id="thead-nth-es2-dps" class="thead"><tr id="tr-5zt-y29-txt"><th id="td-e9m-7bz-2k8"><p id="p-7a3-db0-4gs"><b>参数</b></p></th><th id="td-7oo-wan-y08"><p id="p-miy-evd-7k2"><b>描述</b></p></th></tr></thead><tbody data-tag="tbody" id="tbody-gtc-b3m-yt1" class="tbody"><tr data-tag="tr" id="tr-ar3-17q-m9m" class="tr"><td data-tag="td" id="td-ief-esv-ie8" class="td"><p data-tag="p" id="p-c4s-vxc-aa9" class="p">object_name</p></td><td data-tag="td" id="td-ify-pmu-315" class="td"><p data-tag="p" id="p-kcl-827-z0a" class="p">对象进入回收站后的新名字</p></td></tr></tbody></table> ## 示例 * 删除放在回收站中的索引表 \_\_recycle\_$\_1\_1597387726700872。 ~~~ OceanBase(admin@test)> create table t1(c1 int); Query OK, 0 rows affected (0.09 sec) OceanBase(admin@test)> create index idx on t1(c1); Query OK, 0 rows affected (0.48 sec) OceanBase(admin@test)> drop table t1; Query OK, 0 rows affected (0.03 sec) OceanBase(admin@test)> 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 | +--------------------------------+----------------------------+-------+----------------------------+ 5 rows in set (0.01 sec) OceanBase(admin@test)> purge index __recycle_$_1_1597387726700872; Query OK, 0 rows affected (0.04 sec) ~~~