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