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

2 votes153 views2 answers
Postgres change owner of schema
SQL
1 vote113 views1 answer
Add constraint sql
SQL
1 vote142 views1 answer
Sql set auto increment back to 0
SQL
3 votes119 views3 answers
Your password does not satisfy the current policy requirements
SQL
0 vote131 views1 answer
Add mysql database to power bi web
SQL
0 vote114 views1 answer
Sql create text column limited values
SQL
0 vote123 views2 answers
MySQL said: Authentication plugin 'caching_sha2_password' cannot be loaded: dlopen(/usr/local/lib/plugin/caching_sha2_password.so, 2): image not found
SQL
0 vote134 views3 answers
Insert query in ci
SQL
0 vote117 views1 answer
Sql server select value large text
SQL
0 vote129 views2 answers
Advantages of stored procedures sql
SQL