Create DataBase

To create a new database, SQL have CREATE DATABASE statement.

• Syntax:

  • Option 1. CREATE DATABASE database_name;

  • Option 2. CREATE DATABASE [IF NOT EXISTS] database_name;

  • Option 3. CREATE SCHEMA database_name;

Naming Convention

• Database names have maximum limit of 64 characters.

• Characters, such as ASCII(0), ASCII(255), /, \, and . are not allowed

In the figure below, a syntax to create a database named testdabase is run. You can either press Ctrl + Enter or click Run icon as shown in the figure to run the command. Once run, you will see a message saying 1 row(S) affected. If you refresh SCHEMAS window, then you can see that our testdatabase has been created.