Tuesday, April 12, 2016

Create and Drop Sql programming language

In this lesson we learn SQL syntax that use  for create a new database. Create database syntax use for create a new database on server .You have to give a unique name  for database creation. A example given below. This query create a database named "stuinfo".

Query Example:

Create database stuInfo;

If we want to delete this database . Drop query syntax have to use for that.

Query Example:

Drop database stuInfo;

If  there is existing database with same name . We use this SQL query to create a new database and drop the existing one.

Query Example:

DROP DATABASE IF EXISTS stuInfo;

CREATE DATABASE stuInfo;

No comments:

Post a Comment