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 © 2013 1keydata.com All Rights Reserved.