yes you can do this but you will need to follow this step by step process exactly once done then you can change it however needed .
1. Right click on the database you want to copy and click on "Design"
that will open it up to the DB format of the table .
2. right click on the same table and go to "New Table"
that will open up a blank table of the same design .
3. go back to the first table which you want to copy and click on the top left block which will highlight the whole table and all its fields and hit "Ctrl+C" on your keyboard
that will copy the whole table and all its fields exactly
4. go back to your new table your making and click on the top left block to highlight the whole table again and hit "Ctrl+V" to paste all table options
now that the table is created you can save it by clicking on the X top right of the table and type in whatever name you want BUT DO NOT save it as the same exact name or it will cause huge problems , just save it as copy or new or something until your ready to use it once its ready you can swap names from the 2 back and forth anytime the game server is not running .
5. once saved close out both tables and restart your SQL so the new table will show up
and open both tables by clicking "Edit all Rows"
you will see the old table is full and the new table is empty but exactly the same tables
6. click on the top left box in the old table to highlight all the table contents you want to copy and move to the new table by right clicking on the blue inside the table and go to Copy --> which is when you can also put on notepad to edit and remove any you don't want to keep
final step left click on the new table you just created and right click on the blue inside the table and going to Paste that will put all the lines in the new table and its ready to use . be sure to hit "Execute" on the top before you close it or some of the fields may not be active depending on if you want to change different values of the tables like key restraints or order descending or whatever reason why your changing the tables .
Well good luck that's how you do it and i hope this helps
should you have any problems just send me a message on here and i will be glad to help .