How to Create a New Table From Another Table in Sql Server or Copy Table Structure Only?

 Posted by vishalneeraj-24503 on 10/7/2014 | Category: Sql Server Interview questions | Views: 339 | Points: 40
Answer:

We will use INTO clause to create a new table from any existing tables.
For Example:-
Select * INTO New_Tbl From Existing_Tbl Where 2 = 4;

Here,2 = 4 means condition will be false,so it will create only table structure.


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response