CREATE DATABASE
Creates a new database.
Syntax
CREATE DATABASE [IF NOT EXISTS] <database_name>
[ WITH
[ DESCRIPTION = <description> ]
]
Parameters
| Parameter | Description |
|---|---|
<database_name> | The name of the database. |
DESCRIPTION = 'description' | The engine’s description (up to 64 characters). |
Example
The following example creates a database with non-default properties:
CREATE DATABASE IF NOT EXISTS my_db
WITH DESCRIPTION = 'Being used for testing'