select * into oldtable from newtable where oldtable =newtable

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

Question Posted / naik

Answer Posted / naik

select * into oldtable from newtable where oldtable
=newtable

Is This Answer Correct ?

2 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How would we use distinct statement? What is its use?

1066

What is b tree index?

909

What is the use of nvl work?

990

What are the different types of lock modes in sql server 2000?

936

Can we add a cpu to sql server?

1003

Why we should not use triggers?

961

What area unit the various kinds of info compression introduced in sql server 2008?

1071

What is inline variable assignment?

1019

How many levels of sp nesting is possible?

1045

What are the types of resultset?

959

Does a full backup include transaction log?

960

Explain various data region available in ssrs with their use?

925

What is serializable?

1034

What is pessimistic concurrency?

970

What is the default server name for sql server?

1151