create table with data from another table code example

Example 1: Create table from another table

CREATE TABLE new_table_name AS
    SELECT *
    FROM existing_table_name
    WHERE 0

Example 2: sql create table with columns as another table

SELECT * INTO newtable FROM oldtable WHERE 1 = 0;