How to create an empty table from an existing table?

Total Post:55

Points:275

 229  View(s)
Ratings:
Rate this:
  1. 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