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?

September 09, 2005 01:23:13	#1
Rahul Tripathi	Member Since: Visitor Total Comments: N/A
RE: How will you copy the structure of a table without...
There is one method for copying the structure of table without copying the data is create table NEWTable AS select * from OLDTABLE where 1=2 rahultripathi@myway.com