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 ?    18 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 9 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

Give a example to search fr a string in all stored procedure in sql server.

0 Answers  


How to receive returning result from a query?

0 Answers  


What are the disadvantages of using querystrings to send data from one page to another?

0 Answers  


What are the types of dml?

0 Answers  


What is named calculation? : sql server analysis services, ssas

0 Answers  






Which table keeps the locking information?

0 Answers  


Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?

0 Answers  


How many types of functions are there in sql server?

0 Answers  


Can we add an identity column to decimal datatype?

0 Answers  


how many non clustered index in sql server 2008,2010,2012

2 Answers   Accenture,


what is differencial backup?how to work?Anybody explai it?

2 Answers   HCL,


I have all the primary data files, secondary data files as well as logs. Now, tell me can I still restore the database without having a full backup? : sql server database administration

0 Answers  


Categories