How to create a table in Redshift database

Below is the syntax to create a new table in Redshift database:

CREATE TABLE tablename
(                     
column1 datatype,     
column2 datatype,     
column3 datatype      
);                    

To create a table (with data) from an existing table using a sql query:

CREATE TABLE tablename       
AS                           
SELECT * from existing_table;

Below is the syntax to create a table like an existing table without copying data:

CREATE TABLE tablename                 
LIKE existing_table;                   

or 

CREATE TABLE tablename                 
AS                                     
SELECT * from existing_table where 1=2;
See also  Redshift Tutorials