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 vote146 views1 answer
Print boolean in plsql
SQL
1 vote158 views1 answer
Hackerrank sql test solutions
SQL
3 votes158 views1 answer
Select database in sql
SQL
5 votes163 views3 answers
String concatenation sql server
SQL
0 vote201 views1 answer
Delete from IN subquery
SQL
1 vote179 views3 answers
How to update column name in psql
SQL
0 vote135 views1 answer
Create table employees oracle
SQL
0 vote159 views1 answer
How to create notes in mysql
SQL
-1 vote151 views2 answers
SQL SELECT TOP Equivalent in oracal
SQL
1 vote171 views1 answer
Postgres install unaccent extension
SQL