Answers for "create a table from another table"

Create table from another table

CREATE TABLE new_table_name AS
    SELECT *
    FROM existing_table_name
    WHERE 0

Posted by: Guest on May-25-2021

sql create table with columns as another table

SELECT * INTO newtable FROM oldtable WHERE 1 = 0;

Posted by: Guest on December-07-2020

Code answers related to "create a table from another table"