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




Answers were Sorted based on User's Feedback



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

Answer / hokar

SELECT * INTO tabname1 FROM tabname2 WHERE 1=2 (TO copy
only the structure)

Is This Answer Correct ?    17 Yes 4 No

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

Answer / pradip jain

SELECT * INTO tblNew FROM tblOld WHERE 1=2

Is This Answer Correct ?    7 Yes 0 No

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

Answer / kumar.t

Select * into newnew1 from newnew WHere 1=2

Is This Answer Correct ?    4 Yes 0 No




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

Answer / jaydev

SELECT TOP 0* INTO tabname2 FROM tabname1

Is This Answer Correct ?    5 Yes 3 No

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

Answer / naik

select * into oldtable from newtable where oldtable
=newtable

Is This Answer Correct ?    2 Yes 1 No

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

Answer / kunal sain

create table table_name
as select * from another_table
where 1>2;

Is This Answer Correct ?    7 Yes 8 No

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

Answer / narsing

SELECT * INTO tabname1 FROM tabname2 WHERE 1<>2 (TO copy
only the structure)

Is This Answer Correct ?    0 Yes 3 No

Post New Answer



More SQL Server Interview Questions

i need some interview questions on sql server developer plz any onee send some links.

2 Answers  


1 01 101 01010

0 Answers  


What is the difference between WHERE AND IN? OR 1. SELECT * FROM EMPLOYEE WHERE EMPID=123 2. SELECT * FROM EMPLOYEE WHERE EMPID IN (123) WHAT IS THE DIFFERENCE?

15 Answers   Cap Gemini, Adsys,


What is the difference between temp table and table variable?

8 Answers   Microsoft,


i want to create procedure for create table in sql server 2005 for example create procedure create_table @table varchar(20) as create @table( id int, name char(20) ) but it will get error what is solution?

5 Answers   Aptech,






Why do we backup Active Directory ?

0 Answers  


Wht is SQL Injection Attack ?

3 Answers  


Where do you find the default Index fill factor and how to change it?

0 Answers  


what is the difference between delete,drop and truncate

2 Answers   Honeywell, Zomato,


what is sql injection?

2 Answers  


Once setting replication, is it potential to own a publisher as sixty four bit sql server and distributor or subscribers as a thirty two bit sql server?

0 Answers  


How would you Update the rows which are divisible by 10, given a set of numbers in column?

3 Answers  






Categories