Creating a table with an explicit definition

To create a new blank table, you use a different flavor of the CREATE TABLE statement. This statement takes the following structure:

CREATE TABLE {table_name} (
    {column_name_1} {data_type_1} {column_constraint_1},
    {column_name_2} {data_type_2} {column_constraint_2},
    {column_name_3} {data_type_3} {column_constraint_3},
    …
);

Here, {table_name} is the name of the table, {column_name} is the name of the column, {data_type} is the data type of the column, and {column_constraint} is one or more options giving special properties to the column. Column constraints will be discussed in the subsection that follows. You can start creating your first table by specifying column names and data types. Suppose you want to create a table called employees with columns for the name and salary of employees. The query would look as follows:

CREATE TABLE employees...