SQL CREATE DATABASE Statement
The SQL CREATE DATABASE Statement
The CREATE DATABASE
statement is used to create a new SQL database.
Syntax
CREATE DATABASE databasename;
CREATE DATABASE Example
The following SQL statement creates a database called "testDB":
ExampleGet your own SQL Server
CREATE DATABASE testDB;
Tip: Make sure you have admin privilege before creating any database. Once a
database is created, you can check it in the list of databases with the
following SQL command: SHOW DATABASES
;
Exercise?What is this?
Test your skills by answering a few questions about the topics of this page
What is the purpose of the SQL CREATE DATABASE
statement?