Answers for "sql create 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

SELECT * INTO nome_da_tabela_que_estao_a_mexer_BKP
	FROM nome_da_tabela_que_estao_a_mexer

Posted by: Guest on June-22-2020

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 "sql create table from another table"