# Create a Database (Schema)

By

Paul Tomoiu

●

In 

MySQL, 

database, 

schema

●

Published 2022-12-03

This tutorial explains to you how to create a database (schema) for MySQL database.

You can substitute the keyword SCHEMA instead of DATABASE in MySQL SQL syntax, for example using CREATE SCHEMA instead of CREATE DATABASE . ... Oracle and other enterprise level database solutions make a distinction. Usually a schema is a collection of tables and a Database is a collection of schemas.

Here is an example of adding a database (schema) in MySQL Server:

create database x;
create schema y;

Here is an example of dropping a database (schema) from MySQL Server:

drop schema x;
drop database y;