DROP DATABASE

Function

Delete a database or a schema.

Precautions

Compared to the original MogDB, dolphin's changes to the DROP DATABASE syntax are:

• Add DATABASE resolves to SCHEMA meaning.

Syntax

DROP DATABASE [ IF EXISTS ] database_name ;

Parameter Description

• IF EXISTS

  If the specified database does not exist, issue a NOTICE instead of throwing an error.

• database_name

  The name of the database to delete.

  Range of values: string, name of an existing database.

  Note:

  For B compatibility, if dolphin.b_compatibility_mode is on, the syntax is equivalent to the DROP SCHEMA syntax without dolphin; if dolphin.b_compatibility_mode is off, the syntax is the DROP DATABASE syntax without dolphin.

Examples

See Examples for CREATE DATABASE.

Helpful Links

CREATE DATABASE