SQL Database


Prev Tutorial Next Tutorial

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.

database

Syntax to create database

Syntax

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.

Syntax

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.

Syntax

DROP DATABASE DataBase_Name;  

Prev Tutorial Next Tutorial

Advertisements




Facebook Likes

Advertisements