1-- Use SELECT ... INTO:
2SELECT * INTO my_table_1 FROM my_table;
3-- Structure only:
4SELECT * INTO my_table_1 FROM my_table WHERE 1 <> 1;
1CREATE TABLE employees_copy
2 AS
3 SELECT first_name, last_name, email FROM employees WHERE 1=0;
1#The SELECT INTO statement selects data from one table and inserts it into a different table.
2#The SELECT INTO statement is most often used to create backup copies of tables.
3syntax->SELECT *
4INTO new_table_name [IN externaldatabase]
5FROM old_tablename
6///example///
7SELECT *
8INTO Persons_Backup
9FROM Persons