SQL > Data Definition Language (DDL) > Create Database Statement

A database is a collection of organized data. A database is not the same as the Relational Database Management System (RDBMS). An RDBMS can have one or multiple databases, whereas a database can only belong to one RDBMS. On the other hand, a database can contain one or more tables, whereas a table can only belong to a database.

Therefore, the first step to use RDBMS to store data is to create a database. SQL offers the CREATE DATABASE command, and its syntax is,

CREATE DATABASE "database_name";

If we want to create a database called "HOLIDAYS", we would type in,

CREATE DATABASE HOLIDAYS;

Next: SQL DROP DATABASE




Copyright © 2014 1keydata.com   All Rights Reserved.   Privacy Policy