SQL > Data Definition Language (DDL) > Create Database StatementA 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 theCREATE 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;
|
Saturday, 13 December 2014
SQL CREATE DATABASE
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment