SQL CREATE TABLE Statement

The SQL CREATE TABLE Statement is used to create a new table in a database.

CREATE TABLE Syntax

CREATE TABLE table_name (
   column_1 datatype,
   column_2 datatype,
   column_3 datatype,
   .
   .
   .
   column_n datatype,
);

CREATE TABLE Conditions

• The column parameters specify the names of the columns of the table.
• You should need to gives a columns datatype like VARCHAR, INTEGER, DATA, DECIMAL, CHAR, etc.

EXAMPLE: CREATE TABLE

Suppose, You want to create a "STUDENTS" table, then just use CREATE TABLE statement:

CREATE TABLE STUDENTS (
   ID INT   NOT NULL,
   FULL_NAME VARCHAR (200)    NOT NULL,
   ADDRESS VARCHAR (200),
   CITY VARCHAR (200),
   COUNTRY VARCHAR (200)    NOT NULL
   PRIMARY KEY (ID)
);

CREATED STUDENTS TABLE

NOW, You have STUDENTS table available in your database; just refresh your database and see it.