How to Copy Data and Structure of One table to Another New table select * into newtable from originaltable where 1 = 1 Share This: Facebook Twitter Google+ Stumble Digg