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
);