[TOC] # PURGE DATABASE ## 描述 該語句用于刪除放在回收站的數據庫。 ## 格式 ~~~ PURGE DATABASE object_name; ~~~ ## 參數解釋 <table data-tag="table" id="table-pb6-wc2-mnj" class="table"><colgroup width="360" span="1" data-tag="col" id="col-fbb-ni2-3kd" colwidth="1*" colnum="1" colname="col1" style="width:50%" class="col"></colgroup><colgroup width="360" span="1" data-tag="col" id="col-oqn-1gm-gnn" colwidth="1*" colnum="2" colname="col2" style="width:50%" class="col"></colgroup><thead id="thead-1e1-6my-70c" class="thead"><tr id="tr-k6j-p1s-jiv"><th id="td-ann-kxq-372"><p id="p-hic-man-zs2"><b>參數</b></p></th><th id="td-5hb-6ca-qts"><p id="p-3kb-5gq-c09"><b>描述</b></p></th></tr></thead><tbody data-tag="tbody" id="tbody-7if-gfw-6n1" class="tbody"><tr data-tag="tr" id="tr-9mr-r9z-95z" class="tr"><td data-tag="td" id="td-3du-hmt-9mz" class="td"><p data-tag="p" id="p-deu-n28-4l6" class="p">object_name</p></td><td data-tag="td" id="td-jdj-pic-4hp" class="td"><p data-tag="p" id="p-190-h49-tnc" class="p">對象進入回收站后的新名字</p></td></tr></tbody></table> ## 示例 * 刪除放在回收站的數據庫 \_\_recycle\_$\_1\_1597384386029184。 ~~~ OceanBase(admin@test)> create database db1; Query OK, 1 row affected (0.03 sec) OceanBase(admin@test)> drop database db1; Query OK, 0 rows affected (0.04 sec) OceanBase(admin@test)> show recyclebin; +--------------------------------+---------------+----------+----------------------------+ | OBJECT_NAME | ORIGINAL_NAME | TYPE | CREATETIME | +--------------------------------+---------------+----------+----------------------------+ | __recycle_$_1_1597384386029184 | db1 | DATABASE | 2020-08-14 13:53:06.029367 | +--------------------------------+---------------+----------+----------------------------+ 1 row in set (0.01 sec) OceanBase(admin@test)> purge database __recycle_$_1_1597384386029184; Query OK, 0 rows affected (0.03 sec) OceanBase(admin@test)> show recyclebin; ~~~