Create table

The syntax used to create a new table is as follows.

CREATE TABLE [IF NOT EXISTS] table_name (
column1 datatype(length) column_constraint,
column2 datatype(length) column_constraint,
column3 datatype(length) column_constraint,
table_constraint );

column_constraint specifies the rules that the data stored in the column must follow.