Which command is used to create a table by copying the structure of another table?

 Posted by Abhisek on 1/21/2010 | Category: Sql Server Interview questions | Views: 2632
Answer:

CREATE TABLE .. AS SELECT command
Example:-
CREATE TABLE AS SELECT*FROM WHERE 1=2;


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Posted by: Easwaran on: 8/31/2012 | Points: 10
Please give working code snippet. The above given code is not working. I tried with code CREATE TABLE TestTable AS SELECT*FROM age_unit_type WHERE 1=2;

Login to post response