Home > DeveloperSection > Interviews > How to create an empty table from an existing table?
 Ask Question

How to create an empty table from an existing table?

Total Post:51

Points:255
 95  View(s)
Ratings:
Rate this:

  1. Post:51

    Points:255
    How to create an empty table from an existing table?

    An example will be -. 

    Select * into studentcopy from student where 1=2

    Here, we are copying the student table to another table with the same structure with no rows copied.

Answer

© Copyright © 2010 - 2019 MindStick Software Pvt. Ltd. All Rights Reserved