Select * into newnew1 from newnew WHere 1=2

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

Question Posted / kumar.t

Answer Posted / kumar.t

Is This Answer Correct ?

4 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Is foreign key a primary key?

1108

Can we hide the definition of a stored procedure from a use?

1236

how to restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration

918

What are the properties of primary key?

986

What is used to replicate sessions between instances in coldfusion clusters?

1083

What is a linked server in sql server?

1083

Does sql server 2000 full-text search support clustering?

872

Does any body please help me what question's have asked for SSRS in the interview?

2161

What is the difference between a function and a trigger?

1091

what are the new features introduced in sql server 2000? : Sql server database administration

934

What is sharding?

116

How can I create a report based on a query? : sql server management studio

1027

What are the types of table?

991

What is lookup override?

1053

What is the difference between stored procedure and functions?

1143