How to create a duplicate table in SQL Server

• Login to the connection
• Right click on the Database Name
• Select Tasks
• Select Export Data
• Select Data Source Server Name and Database Name
• Select Destination Server ( if you dont see your server name , add it manually) and Database Name
• Then Select Copy Data from one or more tables or views
• Then Select The Source Table you want to copy the data from                                                 Note : Change the Table Name if you are copying it to same Database
• Then Select Next , check Run Immediately
• Click Finish

Now the table will be created and Data will be copied.