Home > DeveloperSection > Blogs > Create Table Statement in SQL

Create Table Statement in SQL


Database Database 
Ratings:
0 Comment(s)
 1578  View(s)
Rate this:

Create Table Statement in SQL

In this blog, I’m trying to explain the create table statement in sql.

You need tables in database to store data. Create Table statement is used to create tables in database.

Syntax:

CREATE TABLE tablename (column name datatype(size),column name datatype(size));

where

·         tablename - name of the table

·         column name - name of the column

·         datatype - datatype of the column

·         size – size of datatype

Example

CREATE TABLE student(student_id int,student_name varchar(30),student_address varchar(30),student_mobile int,

student_branch varchar(10),student_date_of_birth date);

This statement creates the table name student with column student_id, student_name, student_address, student_mobile, student_branch, student_date_of_birth

 


Don't want to miss updates? Please click the below button!

Follow MindStick