Select top 0 into newtable from oldtable

How can I create a table from another table without copying any values from the old table?

Question Posted / arun

Answer Posted / arun

Select top 0
into newtable
from oldtable

Is This Answer Correct ?

3 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is the recommended total size of your memory optimized tables?

955

role of sql sever 2005 in database rather than any other database

1922

what are isolation levels? : Sql server database administration

969

What is the downside of using udf?

1091

How to get the number of affected rows?

989

What are the advantages of user defined function?

967

What is logon trigger?

1070

Describe in brief authentication modes in sql server.

1009

How to rebuild master databse?

1065

Can you pass expressions to stored procedure parameters?

1010

Is it true, that there is no difference between a rule and a check constraint?

1021

Explain filtered indexes?

974

how many layers of tcp/ip protocol combined of? : Sql server database administration

980

What is sql server programming?

1021

What is the report builder?

139