-- Use SELECT ... INTO: SELECT * INTO my_table_1 FROM my_table; -- Structure only: SELECT * INTO my_table_1 FROM my_table WHERE 1 <> 1;