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

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

Question Posted / narsing

Answer Posted / narsing

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

Is This Answer Correct ?

0 Yes

3 No

Please Help Members By Posting Answers For Below Questions

What is a non clustered primary key?

871

List the different index configurations possible for a table?

881

Explain tablesample?

942

What are the tool windows in sql server management studio? : sql server management studio

1014

Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.

968

What is @@rowcount in sql?

947

What is the process of normalization?

1046

how to create a scrollable cursor with the scroll option? : Sql server database administration

1024

What are parameterized reports?

191

Does full backup break log chain?

910

What is the difference between an index and a unique index?

952

What is cursor in ms sql server?

1084

How do I perform an unattended install of sql server 2000?

1017

Explain primary key in sql server?

970

Suggest a method of joining two tables.

1100