SQL CREATE TABLE Keyword

CREATE TABLE

The CREATE TABLE command creates a new table in the database.

The following SQL creates a table called "Persons" that contains five columns: PersonID, LastName, FirstName, Address, and City:

CREATE TABLE Persons (
    PersonID int,
    LastName varchar(255),
    FirstName varchar(255),
    Address varchar(255),
    City varchar(255)
);

The following SQL creates a new table called "TestTables" (which is a copy of two columns of the "Customers" table):

CREATE TABLE TestTable AS
SELECT customername, contactname
FROM customers;