To create new entities in a data source, use CREATE TABLE statements.

CREATE TABLE Syntax

The CREATE TABLE statement specifies the table name, a comma-separated list of column names, and the primary keys of the table, as shown in the following example:

CREATE TABLE <table_name> [ IF [ NOT EXISTS ] ]
(
  {
     <column_name> <data_type>
     [ NOT NULL ]
     [ DEFAULT <literal> ]
     [ PRIMARY KEY ]
     [ UNIQUE ]
  } |  PRIMARY KEY ( <column_name> [ , ... ] )
  [ , ... ]
)

The following example statement creates a MyCustomers table in the data source with name, age, and address columns:

CREATE TABLE IF NOT EXISTS [MyCustomers] (name VARCHAR(20), age INT, address VARCHAR(20))