What is SQL Database
Database Darabase is the collection of tables, using sql you can insert or retrieve data from database. First you need to create database, you can also drop a database.
Syntax to create database
CREATE DATABASE DataBase_Name;
Note: In MySQL, first you need to create database then create table, but in case of Oracle no need to create database, you can create table directly.
By using SQL RENAME DATABASE statement you can change the name of a database. Following syntax are use for rename database.
RENAME DATABASE old_db_name TO new_db_name;
DROP statement is used to delete or remove indexes from a table in the database. You can also delete existing database.
DROP DATABASE DataBase_Name;