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: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

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

DO YOU WISH TO IMPROVE YOUR BUSINESS ?

Once you’ve signed up as a user for a sponsorship on MindStick network, you will receive sponsored posting opportunities to apply for. It’s a great way to promote your product as a brand.

Yes, help me to improve my business No thanks x