What is the SQL command to create a new database?

The SQL command to create a new database is: CREATE DATABASE "database_name"; For example, to create a database called HOLIDAYS, you would run: CREATE DATABASE HOLIDAYS;

What is the difference between a database and an RDBMS?

A Relational Database Management System (RDBMS) is the software that manages data. A database is a collection of organized data within the RDBMS. An RDBMS can contain one or multiple databases, while a database belongs to only one RDBMS.

Can I have multiple databases in one RDBMS?

Yes. An RDBMS can host one or multiple databases, each containing its own set of tables, views, indexes, and other objects. Each database is an independent collection of organized data within the RDBMS.

SQL CREATE DATABASE

SQL > Data Definition Language (DDL) > Create Database Statement

A database is a collection of organized data. A database is not the same as the Relational Database Management System (RDBMS). An RDBMS can have one or multiple databases, whereas a database can only belong to one RDBMS. On the other hand, a database can contain one or more tables, whereas a table can only belong to a database.

The SQL CREATE DATABASE command creates a new database within your RDBMS. A database is a container for tables and other objects, and an RDBMS can host multiple databases.

Therefore, the first step to use RDBMS to store data is to create a database. SQL offers the CREATE DATABASE command, and its syntax is,

CREATE DATABASE "database_name";

If we want to create a database called "HOLIDAYS", we would type in,

CREATE DATABASE HOLIDAYS;

Frequently Asked Questions

What is the SQL command to create a new database?: The SQL command is: CREATE DATABASE "database_name"; For example, to create a database called HOLIDAYS: CREATE DATABASE HOLIDAYS;
What is the difference between a database and an RDBMS?: An RDBMS (Relational Database Management System) is the software engine (e.g., MySQL, PostgreSQL, SQL Server) that manages data. A database is a named collection of organized data hosted within that RDBMS. One RDBMS can contain many databases.
Can I have multiple databases in one RDBMS?: Yes. An RDBMS can host multiple independent databases simultaneously, each with its own tables, views, and indexes. This is common in production environments where separate applications share the same database server.
How do I delete a database in SQL?: To delete a database, use the DROP DATABASE command: DROP DATABASE "database_name"; Be careful — this permanently removes the database and all its contents.

Next: SQL DROP DATABASE

This page was last updated on March 19, 2026.

AdBlock Detected!

Our website is made possible by displaying ads to our visitors. Please supporting us by whitelisting our website.

SQL CREATE DATABASE

Frequently Asked Questions

Related Topics

AdBlock Detected!