DROP DATABASE

Purpose

This statement is used to delete a database.

Syntax

DROP DATABASE [IF EXISTS] database_name

Parameters

Examples

• Delete the test2 database.

  obclient> DROP DATABASE test2;
  

• Attempt to delete a non-existent database named notest.

  obclient> DROP DATABASE notest;
  

  Expected return result:

  ERROR 1008 (HY000): Can't drop database 'notest'; database doesn't exist
  

  obclient> DROP DATABASE IF EXISTS notest;
  

  Expected return result:

  Query OK, 0 rows affected, 1 warning
  

  obclient> SHOW WARNINGS;
  

  Expected return result:

  
  +-------+------+------------------------------------------------------+
  | Level | Code | Message                                              |
  +-------+------+------------------------------------------------------+
  | Note  | 1008 | Can't drop database 'notest'; database doesn't exist |
  +-------+------+------------------------------------------------------+
  1 row in set