Create a duplicate table in MS SQL February 6th, 2009Ever wanted to replicate a table and its contents in MS SQL? heres how: SELECT * INTO NewTable FROM OldTable Want to copy just the structure and not the content? SELECT TOP 0 * INTO NewTable from OldTable