CREATE TABLE statement is used to create a table in a database.

SYNTAX

CREATE TABLE table_name(
 column1 datatype,
 column2 datatype,
 .....
 .....
 columnN datatype,
 PRIMARY KEY(column_name )
 );

 

EXAMPLE

CREATE TABLE STUDENT
(
 ID INT NOT NULL,
 NAME VARCHAR (20) NOT NULL,
 AGE INT NOT NULL,
 ADDRESS CHAR (25) ,
 PRIMARY KEY (ID)
);

Table created.

Explaination

STUDENT is name of the table having 4 columns and 1 constraints

Column 1 :  ID of INTEGER data type and having Primary Key Constraint
Column 2 :  NAME of  VARCHAR data type
Column 3 :  AGE of INTEGER data type
Column 4:  ADDRESS of  CHARACTER data type