🚨 Time is Running Out: Reserve Your Spot in the Lucky Draw & Claim Rewards! START NOW

Code has been added to clipboard!

Home| SQL | SQL Commands| CREATE DATABASE

Creating an SQL Database

Reading time 1 min
Published Aug 9, 2017
Updated Oct 9, 2019

TL;DR – The SQL CREATE DATABASE command is used to produce a new database.

Syntax of SQL CREATE DATABASE

Example 
CREATE DATABASE dbname;

Producing a database called testingDB

Example 
CREATE DATABASE testingDB;
Previous Topic Next Topic
Learn SQL
Introduction
Syntax
Data Types
Server Data Types
Commands
Commands List
Wildcards
Constraints
Aggregate Functions
Date Functions
Date Format
Injection
SQL Server Hosting
Views
Auto-incrementation
SQL Operators
AS
AND & OR
IN
BETWEEN
WHERE
GROUP BY
HAVING
ORDER BY
LIKE
NOT
NOT EQUAL
UNION
NULL
NOT NULL
DEFAULT
UNIQUE
FOREIGN KEY
PRIMARY KEY
CHECK
Indexes
SQL Commands
ALTER TABLE
CREATE DATABASE
CREATE TABLE
DELETE
DROP
INSERT INTO SELECT
INSERT INTO
SELECT
SELECT DISTINCT
SELECT INTO
SELECT TOP
UPDATE
FULL OUTER JOIN
INNER JOIN
JOIN
LEFT JOIN
RIGHT JOIN
AVG()
COUNT
FIRST
LAST
MAX
MIN()
SUM()
LEN
UCASE
MID
NOW
ROUND
FORMAT
LOWER
CONVERT
ISNULL
Best-rated MOOCs to Learn Programming:
DataCamp Review
9.8
Read review
Udacity Review
9.6
Read review
edX Review
9.4
Read review

Related Posts

Learn SQL: Main Concepts and Principles Explained

Learn SQL online: find out what does SQL stand for & learn SQL with many examples and explanations, presented in this complete learn SQL tutorial.

3 min read
Using SQL NOT in Your Database

SQL NOT condition explained: how and when to use it? A complete SQL NOT condition guide and rookie-friendly examples to make using SQL NOT easy.

2 min read
4 examples
Prepared Statements With PHP PDO and MySQLi: Differences and Examples

PHP PDO tutorial: find details on how to easily use PDO PHP in your code. Learn all about PHP Prepared Statements with this PHP PDO guide.

3 min read
2 examples

Related Code Examples

SQL
Adding Values With Insert Into SQL

SQL
Multiple Tables With SQL SELECT INTO

SQL
Copying Columns With SQL INSERT INTO, SELECT

SQL
Getting Table Data With SQL Commands

SQL
Getting Three Specific Cells With SQL SELECT TOP

SQL
Use of SQL DROP DATABASE
EXCLUSIVE OFFER: GET 25% OFF

EXCLUSIVE OFFER: GET 25% OFF

Save Big With DataCamp Promo Code
Days
Hours
Minutes
Seconds
GET 25% OFF