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.


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


·         tablename - name of the table

·         column name - name of the column

·         datatype - datatype of the column

·         size – size of datatype

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


  Modified On Sep-18-2014 01:24:12 PM

Leave Comment