Create a duplicate table in MS SQL

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

Amit is a digital consultant with a passion for design, interaction and usability. In his free time if he's not at the gym he's traveling the world.

View all posts by: Amit

David says:

Thanks alot. It worked for me

Sundhas says:

It doesnt work at my end 🙁
It says : Sysntax error : INTO clause is not allowed
what to do?

webmotionuk says:
28th October 2009 at 12:28 pm
@sundhas, can you please show us what sort of query you ran?

Sergio says:

🙂 It works! Thank you. I love this kind of tip.

Create a duplicate table in MS SQLFriday, February 6th, 2009