Using Querious, you can easily duplicate a table including all of its data on the same server into the same database, a different database, or even copy it to a completely different server. And, not only can you duplicate a table this way, you can duplicate an entire database. This is a powerful feature that is a great time saver.
To duplicate a database or table:
Selecting the "Include table content" option will copy the data of the selected table (all tables when duplicating an entire database) into the new table(s). When duplicating a database, all views, triggers, functions, procedures, and events will also be created in the new database.