[TOC] # PURGE TABLE ## 描述 该语句用于删除放在回收站的表。 ## 格式 ~~~ PURGE TABLE object_name; ~~~ ## 参数解释 <table data-tag="table" id="table-2fd-n2o-6nf" class="table"><colgroup width="360" span="1" data-tag="col" id="col-orj-0fq-3vw" colwidth="1*" colnum="1" colname="col1" style="width:50%" class="col"></colgroup><colgroup width="360" span="1" data-tag="col" id="col-0e2-w7x-hkj" colwidth="1*" colnum="2" colname="col2" style="width:50%" class="col"></colgroup><thead id="thead-7ec-lgv-ur1" class="thead"><tr id="tr-wjw-wo7-yhq"><th id="td-wbz-ivp-721"><p id="p-jy1-1v4-pua"><b>参数</b></p></th><th id="td-qa0-yd7-36z"><p id="p-bmj-oiw-hs1"><b>描述</b></p></th></tr></thead><tbody data-tag="tbody" id="tbody-tfq-qbi-3n9" class="tbody"><tr data-tag="tr" id="tr-x4u-bbg-gjv" class="tr"><td data-tag="td" id="td-nzm-z8d-yob" class="td"><p data-tag="p" id="p-jt3-0s6-lwb" class="p">object_name</p></td><td data-tag="td" id="td-yeh-nmb-qg5" class="td"><p data-tag="p" id="p-79d-7vb-try" class="p">对象进入回收站后的新名字</p></td></tr></tbody></table> ## 示例 * 删除放在回收站中的表 \_\_recycle\_$\_1\_1099511628776\_1099511677778。 ~~~ OceanBase(admin@test)> create table test(c1 int); Query OK, 0 rows affected (0.16 sec) OceanBase(admin@test)> drop table test; Query OK, 0 rows affected (0.03 sec) OceanBase(admin@test)> 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 (0.02 sec) OceanBase(admin@test)> purge table __recycle_$_1_1099511628776_1099511677778; Query OK, 0 rows affected (0.04 sec) ~~~