Friday, 18 December 2015

How can you create an empty table from an existing table?

Example will be -.
 Select * into studentcopy from student where 1=2
1
Select * into studentcopy from student where 1=2
 Here, we are copying student table to another table with the same structure with no rows copied.

No comments:

Post a Comment