SQL CREATE DATABASE

The CREATE DATABASE statement in SQL is used to create a new database. This is a fundamental operation in database management, allowing you to establish a new database environment where you can create tables, store data, and manage it effectively.

Here's a general syntax for the CREATE DATABASE statement:

CREATE DATABASE database_name;

Example

Let's go through an example to create a new database named SampleDB.

1. Basic Example:

CREATE DATABASE SampleDB;

When this command is executed, SQL Server will create a new database named SampleDB. The result will be an empty database ready for tables and data to be added.

2. Specifying Additional Options:

In many SQL database systems, you can specify additional options such as the character set and collation. For example, in MySQL:

CREATE DATABASE SampleDB
CHARACTER SET utf8mb4
COLLATE utf8mb4_unicode_ci;

Verification

After creating the database, you can verify its creation by listing all databases. In MySQL, you can use:

SHOW DATABASES;

In PostgreSQL:

\l

Example with Output

1. Create Database:

CREATE DATABASE SampleDB;

Output:

Query OK, 1 row affected (0.00 sec)

2. List Databases (in MySQL):

SHOW DATABASES;

Output:

+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| SampleDB           |
| sys                |
+--------------------+
5 rows in set (0.00 sec)

Notes

• The CREATE DATABASE statement requires appropriate permissions. Usually, only database administrators or users with special privileges can create new databases.
• The database_name should be unique within the database server.
• The specific syntax and options available for CREATE DATABASE can vary slightly between different SQL database systems (e.g., MySQL, PostgreSQL, SQL Server).

By understanding and using the CREATE DATABASE statement, you can establish new databases to organize and manage your data effectively.