Answers for "clone table in sql"

SQL
1

duplicate table sql

CREATE TABLE new_table LIKE original_table;
Posted by: Guest on July-31-2021
0

copy table in sql

CREATE TABLE employees_copy
 AS 
 SELECT first_name, last_name, email FROM employees WHERE 1=0;
Posted by: Guest on September-07-2021

Code answers related to "SQL"

Browse Popular Code Answers by Language