Answer Detail: RE: How will you copy the structure of a table without...

GeekInterview.com > Interview Questions > Database > SQL Server

Print |

Question: How will you copy the structure of a table without copying the data?

May 05, 2007 05:18:32	#8
Omprakash	Member Since: Visitor Total Comments: N/A
RE: How will you copy the structure of a table without...
Hi All SELECT TOP 0 * INTO Test1 FROM Test The above query creates only structure. This works in SQL Server 2000 and 2005 also.