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 are the database objects? : SQL Server Architecture

1049

Why we need sql server?

965

Tell me the phases a transaction has to undergo?

962

What are exact numeric data types in ms sql server?

1076

Tell me extended events in sql server 2008?

996

what is normalization? Explain different levels of normalization? : Sql server database administration

1327

Explain about remote stored procedure?

1008

How do I open a .db file?

1038

Can foreign key be deleted?

924

What are the differences between char and nchar in ms sql server?

1087

What is the security principal at the database level that represents your session?

942

How dts is used to extract, transform and consolidate data?

1073

Where the sql logs gets stored? : sql server database administration

964

What is rank function?

1031

How to drop an existing schema in ms sql server?

1103