Back to SQL Notes
Topic #47

SQL Create DB

CREATE DATABASE initialises the container that will hold all of a project's tables. It is the first step in setting up any new system.


The SQL CREATE DATABASE Statement

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

Tip: You need administrative privileges to create a new database.

Syntax

CREATE DATABASE database_name;

CREATE DATABASE Example

The following SQL statement creates a database called "testDB":

Example

CREATE DATABASE testDB;

Show Databases

Once a database is created, you can check it in the list of databases with the following SQL command:

Syntax for SQL Server

SELECT name FROM sys.databases;

Syntax for MySQL

SHOW DATABASES;

Want to go beyond the notes?

Join Coding Now Tech Institute's SQL course — live mentorship, real projects, and 100% placement support.

Enroll Now — Free Demo Available

SQL Create DB – FAQs

Quick answers about learning SQL Create DB in SQL.

This free note from Coding Now Tech Institute explains SQL Create DB in SQL — concept, syntax and worked code examples you can copy, run and revise before interviews.
Yes. Every SQL topic on Coding Now Tech Institute, including SQL Create DB, is 100% free with no signup required.
With focused practice, most students grasp SQL Create DB in 1–3 days from these notes; pairing it with Coding Now Tech Institute's mentor-led course takes you to job-ready depth faster.
Use the code examples in this note, then ask doubts for free on the Coding Now Tech Institute Community (/community) — expert instructors answer within 24 hours.
Call NowEnroll Now