How to create a new table from existing table in SQL

• Create a new table structure with another table in SQL

  CREATE TABLE new_table
  AS (SELECT * FROM old_table WHERE 1=2);
  

  This SQL query will create a new table with the structure of another table in SQL.  This Query will only create the table structure but do not copy data from another table that you are used to creating the new one.

  It will not copy indexes and keys.

• Create a new table structure with keys and indexes using another table in SQL

  CREATE TABLE new_table LIKE existing_table;
  

  This SQL query creates a new table structure with keys and indexes from another existing table.

• Create a new table structure with data from another table in SQL

  CREATE TABLE new_table LIKE existing_table;
  INSERT INTO new_table SELECT * FROM existing_table;
  

  This Query will create a new table structure and insert data in it from the existing table in SQL. The first query (CREATE TABLE new_table LIKE existing_table) is used to create the table structure with keys and indexes. 

  Second query (INSERT INTO new_table SELECT * FROM existing_table;) is used to insert data into the table (newly created table) from the existing table.

Back to code snippet queries related sql