Create Database in SQL,SQL Tutorial

This page discusses - Create Database in SQL,SQL Tutorial

Create a database


In this section, we will teach you to create a database. 

First of all, display all databases by show databases. This helps to find out the existing database. Then create a database using the given syntax and give the suitable name of database.






CREATE DATABASE database_name;

Then create connection with database. The connection  is included in the names of the database. 

Create a Table: the following query creates a table
CREATE TABLE table_name
column_name1 data_type,

Yet the table does not have any data. 

In the given example we show the use of the create to make a table email and populate it with the field named LName, FName and email_add.

LName varchar(20),
FName varchar(20),
email_add varchar(40)


Share on Google+Share on Google+

Create Database in SQL,SQL Tutorial

Posted on: April 18, 2011 If you enjoyed this post then why not add us on Google+? Add us to your Circles



Discuss: Create Database in SQL,SQL Tutorial  

Post your Comment

Your Name (*) :
Your Email :
Subject (*):
Your Comment (*):
  Reload Image