OceanBase DROP DATABASE

描述

DROP DATABASE 用于刪除數(shù)據(jù)庫。

格式

drop_database_stmt:
    DROP DATABASE [IF EXISTS] database_name;

參數(shù)解釋

示例

• 刪除數(shù)據(jù)庫 test2。

OceanBase(admin@test)>drop database test2;
Query OK, 0 rows affected (0.03 sec)

• 刪除不存在的數(shù)據(jù)庫 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)