SQL – CREATE TABLE

CREATE TABLE

The CREATE TABLE Statement is used to create a TABLE in a Database.

Syntax:

CREATE TABLE table_name

(

Column_name1 data_type(size),

Column_name2 data_type(size),

Column_name3 data_type(size)

);

Here data_type specifies the type of data (int, char, varchar…etc) than can be stored in the column.

Example:

CREATE TABLE EMPLOYEES

(

EMPLOYEE_ID int,

FIRST_NAME varchar (20),

LAST_NAME varchar (20),

SALARY int

);