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:
Example
CREATE TABLE Persons
(
PersonID int,
LastName varchar(255),
FirstName varchar(255),
Address varchar(255),
City varchar(255)
);CREATE TABLE Using Another Table
The following SQL creates a new table called "TestTables" (which is a copy of two columns of the "Customers" table):
Example
CREATE TABLE TestTable AS
SELECT customername, contactname
FROM
customers;