SQL CREATE DATABASE Statement

The CREATE DATABASE Statement is used to create a database. After creating a database, we can create several other database objects (tables, views, procedures etc.) into it. The user should have admin privileges for creating database.:

Let's see the syntax of SQL CREATE DATABASE:


 SQL CREATE DATABASE Statement:

CREATE DATABASE database_name



[COLLATE collation_name ]

				

In the above query,

  • database_name - is the name of the database to be created
  • collation_name - is the default collation (character set) for the database.

This, collation_name, is an optional field and if not provided then Default Collation is assigned to database.

CREATE DATABASE Example:

  • If you want to create database MyDatabase with default collation, the statement would be like CREATE DATABASE MyDatabase ;
  • If you want to create database MyOtherDatabase with collation a€śLatin General then statement would be like
  • CREATE DATABASE MyOtherDatabase COLLATE Latin1_General_CP1_CI_AS;

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.