CREATE DATABASE Examples
Let’s look at examples of how to create a database in SQL and how to verify database creation by listing databases in the server.
Creating Your First SQL Database
To create a new database in SQL we use the CREATE DATABASE command and then we mention the name of the database. Note that blank spaces are not allowed in the name of the database, we can only use underscore (_).
As an example, we will create a new database with the name “w3wiki”.
SQL Query:
CREATE DATABASE w3wiki;
Output
Creating a new database
Database Successfully Created!!
SQL CREATE DATABASE
SQL CREATE DATABASE statement creates a new database in SQL-based DBMS.
Contact Us