SQL CREATE DATABASE is a command that creates a new database in RDBMS, such as MySQL, SQL Server, Oracle, and others. The statement creates an empty database with the user's specified name.
The basic syntax for creating a new database using SQL is:
Syntax:
CREATE DATABASE database_name;
For example, to create a new database named "mydb", you would use the following SQL statement:
Example:
CREATE DATABASE mydb;
When the above statement is executed, a new database with the specified name is created. The new database will be empty and contain no tables. You can then use other SQL statements to create tables, insert data, and perform different operations on the new database.