SQL Database

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.

Rename Database

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 Database

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;