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