3
Reply

What command is used to create a table by copying the structure of another table?

Pradeep

Pradeep

16y
6.1k
0
Reply
    umashankar sahu
    SELECT * INTO New Table FROM Exiting table SELECT * INTO mytable from HumanResources.Employee
    umashankar sahu
    13y
    0
    yakoob pasha
    We can use :

    SELECT Column_list INTO New_Table_Name FROM Original_Table_Name

    Ex:

    select * into customers1 from cusotmers

    Thank you
    yakoob pasha
    15y
    0
    Priyadarshi Datta
    CREATE TABLE As SELECT Command.

    Explanation:
    To copy only the structure the where clause of the SELECT command should have a FALSE statement.
    Ex:
    CREATE TABLE newtable as SELECT * FROM exixtingtable
    WHERE 1 = 2

    If WHERE condition is true then all the rows satisfying the condition  will be copied to the newtable.
    Priyadarshi Datta
    16y
    0
Message