[TOC] # DROP DATABASE ## 描述 DROP DATABASE 用于删除数据库。 ## 格式 ~~~ drop_database_stmt: DROP DATABASE [IF EXISTS] database_name; ~~~ ## 参数解释 <table data-tag="table" id="table-tb0-me7-49q" class="table"><colgroup width="240" span="1" data-tag="col" id="col-fvg-aga-f9z" colwidth="1*" colnum="1" colname="col1" style="width:50%" class="col"></colgroup><colgroup width="485" span="1" data-tag="col" id="col-gvp-7lq-o2y" colwidth="1*" colnum="2" colname="col2" style="width:50%" class="col"></colgroup><thead id="thead-282-bfe-sz6" class="thead"><tr id="tr-pk0-1lb-w9g"><th id="td-1c8-9ps-8nx"><p id="p-ib1-vid-pgy"><b>参数</b></p></th><th id="td-xb2-x2k-tqk"><p id="p-unx-e4h-0jt"><b>描述</b></p></th></tr></thead><tbody data-tag="tbody" id="tbody-o1z-oay-0ns" class="tbody"><tr data-tag="tr" id="tr-trz-ekd-g5z" class="tr"><td data-tag="td" id="td-42a-n8k-rli" class="td"><p data-tag="p" id="p-0h2-eiv-qx5" class="p">IF EXISTS</p></td><td data-tag="td" id="td-mhb-aeu-yow" class="td"><p data-tag="p" id="p-hz6-mj1-tm2" class="p">用于防止当数据库不存在时发生错误。</p></td></tr><tr data-tag="tr" id="tr-wzm-2fx-1su" class="tr"><td data-tag="td" id="td-bkp-9hi-u9o" class="td"><p data-tag="p" id="p-gdl-fjo-8lz" class="p">database_name</p></td><td data-tag="td" id="td-0yr-0yp-ze9" class="td"><p data-tag="p" id="p-zi6-bz1-4af" class="p">指定待删除的数据库名。</p></td></tr></tbody></table> ## 示例 * 删除数据库 test2。 ~~~ OceanBase(admin@test)>drop database test2; Query OK, 0 rows affected (0.03 sec) ~~~ * 删除不存在的数据库 notest。 ~~~ OceanBase(admin@test)>drop database notest; ERROR 1008 (HY000): Can't drop database 'notest'; database doesn't exist OceanBase(admin@test)>drop database if exists notest; Query OK, 0 rows affected, 1 warning (0.00 sec) OceanBase(admin@test)>show warnings; +-------+------+------------------------------------------------------+ | Level | Code | Message | +-------+------+------------------------------------------------------+ | Note | 1008 | Can't drop database 'notest'; database doesn't exist | +-------+------+------------------------------------------------------+ 1 row in set (0.00 sec) ~~~