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;