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

What is the concept of optimization?

995

Explain what are the restrictions that views have to follow? : SQL Server Architecture

999

How to set a database state to offline in ms sql server?

973

What does COMMIT command do?

1012

What are sp_configure commands and set commands?

961

Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?

2460

Other than truncate statement, which other command can by-pass the trigger on the tables?

1076

What do you mean by data manipulation language?

954

How to change the ownership of a schema in ms sql server?

1103

What is sub-query in sql server? Explain its properties.

1046

Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?

941

Â Explain what is sql override for a source taLle in a mapping?

953

What are functions in the sql server?

1139

How to create and drop temp table in sql server?

1007

Tell me what is use of except clause? How it differs from not in clause?

909