CREATE DATABASE

CREATE DATABASE

The CREATE DATABASE statement creates a new, empty database.

Syntax

CREATE DATABASE mydb;

Show all databases

SHOW DATABASES;      -- MySQL

Use a database

Before working on a database, select it:

USE mydb;            -- MySQL

In SQL Server:

USE mydb;
GO

DROP DATABASE

Removes the whole database:

DROP DATABASE mydb;

Backing up a database

SQL Server:

BACKUP DATABASE mydb
TO DISK = 'D:\backups\mydb.bak';

With a differential backup (only changes since the last full backup):

BACKUP DATABASE mydb
TO DISK = 'D:\backups\mydb.bak'
WITH DIFFERENTIAL;

TL;DR

• CREATE DATABASE makes a new database.
• USE selects the database you work with.
• DROP DATABASE deletes it completely.
• Backups protect your data.