SQL Create Table.

Create a Database Table with Columns

Tables are organized into rows and columns and must have a name.

CREATE TABLE table_name
(column_name datatype [NULL | NOT NULL]
[, column_name datatype [NULL| NOT NULL] ]...);

CREATE TABLE Customer (
 CUSTOMER_ID INT NOT NULL,
 FIRST_NAME VARCHAR(20) NULL,
 LAST_NAME VARCHAR(20),
 EMAIL VARCHAR(30) NULL
 );

1. Start with, "Create table" and then the table name (here Customer).
2. Type a open parenthesis as a start to include columns.
3. For each column write the name first.
4. Follow by a space and then the data type.
5. Optional write the keywords NULL or NOT NULL whether the column require a value or can be null (The default is NULL).
6. End the included columns and table definition with a Closing parenthesis and a semicolon.