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

1 Answers

Anonymous User
Anonymous User

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.

report abuse

Answer

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