SQL CREATE Database

SQL CREATE Database

The SQL CREATE DATABASE statement is used by a developer to create a database.

Let's see the syntax of SQL CREATE DATABASE:

1. CREATE DATABASE DataBaseName;  

If you want to add tables in that database, you can use CREATE TABLE statement.

In MySQL, you need to create database first then table. But, you don't need to create database in Oracle. In Oracle database, you can create table directly.

You can also rename, drop and select database that is covered in next pages.

We should always remember that database name should be unique in the RDBMS.