Uday Dodiya
Write a query to create a new table which consists of data and structure copied from the other table.
By Uday Dodiya in .NET on Aug 28 2022
  • Uday Dodiya
    Aug, 2022 28

    Using the SELECT INTO command:

    1. SELECT * INTO NewTable FROM EmployeeInfo WHERE 1 = 0;

    Using the CREATE command :

    1. CREATE TABLE NewTable AS SELECT * FROM EmployeeInfo;

    • 1


Most Popular Job Functions


MOST LIKED QUESTIONS