SQL Database

Advertisements

First Query in SQL Naming Conversion in SQL

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;  

First Query in SQL Naming Conversion in SQL

Advertisements

Buy This Ad Space @$20 per Month, Ad Size 600X200 Contact on: hitesh.xc@gmail.com or 9999595223

Pure VPN Privide Lowest Price VPN Just @ $1.65. Per Month with Non Detected IP Lowest Price Non Detected IP VPN

Magenet is best Adsense Alternative here we earn $2 for single link, Here we get links ads. Magenet

For Projects 9999595223

Google Advertisements


Buy Websites 9999595223

Buy College Projects with Documentation Contact on whatsapp 9999595223. Contact on: hitesh.xc@gmail.com or 9999595223 Try this Keyword C++ Programs

Advertisements