If you need the similar structure of the table with different tablename, it’s better to duplicate r copy the table structure than creating a new table from scratch. It is easy to duplicate the table structure and rename it.
Select any database table and right click and click on the option Duplicate Table Structure /Data as shown below
Now a Window Copy Table opens, which shows the fields and even allows you to rename table.
Click on Copy
You will see a message as Copy of Table Successful
You can also check out for How to export database as Sql statements
