Answers for "Create table from another table"

Create table from another table

CREATE TABLE new_table_name AS
    SELECT *
    FROM existing_table_name
    WHERE 0

Posted by: Guest on May-25-2021

create a table from one field of another table

SQL> CREATE TABLE SALARY AS
   SELECT ID, SALARY
   FROM CUSTOMERS;

Posted by: Guest on July-09-2020

sql create table with columns as another table

SELECT * INTO newtable FROM oldtable WHERE 1 = 0;

Posted by: Guest on December-07-2020

Code answers related to "Create table from another table"