Ever 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