SQL CREATE DATABASE

The CREATE DATABASE statement is used to create a new database in SQL. A database stores tables, views, and other objects that help organize and manage data efficiently.

 

Syntax of SQL CREATE DATABASE

CREATE DATABASE database_name;

• database_name: The name of the database to be created.

 

CREATE DATABASE database_name CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

 

Key Features of SQL CREATE DATABASE

• Creates a new database.
• The database name must be unique in the system.
• Requires appropriate permissions (e.g., CREATE DATABASE privilege).
• Default settings like collation and character set can be specified.

 

Example of SQL CREATE DATABASE

CREATE DATABASE SchoolDB;

Output:

A new database named SchoolDB is created.

To use this database, run:

USE SchoolDB;

 

Checking Existing Databases

To list all databases:

SHOW DATABASES;

Dropping a Database

To delete an existing database:

DROP DATABASE SchoolDB;

 

Summary

• CREATE DATABASE is used to create a new database.
• Ensure the database name is unique.
• Use SHOW DATABASES to verify its creation.
• Use DROP DATABASE to delete it if needed.