Copy table in sql

Into sql

#The SELECT INTO statement selects data from one table and inserts it into a different table. 
#The SELECT INTO statement is most often used to create backup copies of tables. 
syntax->SELECT *
INTO new_table_name [IN externaldatabase]
FROM old_tablename 
///example///
SELECT *
INTO Persons_Backup
FROM Persons

Copy table in sql

CREATE TABLE employees_copy
 AS 
 SELECT first_name, last_name, email FROM employees WHERE 1=0;

Source: rebellionrider.com

Similar codes

0 vote108 views4 answers
Sql server date format yyyy-mm-dd
SQL
36 votes96 views3 answers
Finding duplicate column values in table with sql
SQL
0 vote94 views1 answer
Mysql case when on date
SQL
0 vote104 views1 answer
Sql select random procentage from rows
SQL
0 vote122 views1 answer
Hallo
SQL
0 vote124 views1 answer
Sqlalchemy empty table
SQL
39 votes205 views5 answers
Sql drop column
SQL
4 votes101 views2 answers
Dbms_scheduler stop job
SQL
1 vote104 views1 answer
Select if then postgresql
SQL
0 vote109 views1 answer
Databricks install odbc driver connect to sql server
SQL