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 do you create an execution plan?

885

How to create an identity column?

1137

Explain a differential backup?

948

Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?

995

What are the differences between having and where clause.

920

List layers of abstraction microsoft architectured to provide relational db through cloud platform ?

181

What are tables in sql server?

962

What is the difference between count and distinct count?

842

How can we call UDF(User Define Function) using C# code in ASP.net ?

6797

How to add the custom code in Report?

117

What are the components of dbms?

907

What are the difficulties faced in cube development? : sql server analysis services, ssas

997

Write an sql query to sort a table according to the amounts in a row and find the second largest amount.

879

Explain foreign key in sql server?

974

How to how to convert numeric expression data types using the convert() function??

989