CREATE DATABASE

The CREATE DATABASE statement creates a new, empty database.

Syntax

sql

### CREATE DATABASE mydb;

Show all databases

sql

### SHOW DATABASES; - MySQL

Use a database

Before working on a database, select it:

sql

### USE mydb; - MySQL

In SQL Server:

sql

### USE mydb;
GO

DROP DATABASE

Removes the whole database:

sql

### DROP DATABASE mydb;

Backing up a database

SQL Server:

sql

### BACKUP DATABASE mydb

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

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

sql

### 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.