create table from another table code example

Example 1: Create table from another table

CREATE TABLE new_table_name AS
    SELECT *
    FROM existing_table_name
    WHERE 0

Example 2: create a table from one field of another table

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

Example 3: sql create table with columns as another table

SELECT * INTO newtable FROM oldtable WHERE 1 = 0;

Tags:

Sql Example

Related