Creating a Copy of a Database Object

Last modified: June 26, 2023

dbForge Fusion for MySQL gives you the duplicate object feature. You can make an exact copy of a database object in the same or different database of the same server. It can be very useful for database designers.

To copy an object, right-click its node and select Duplicate Object on the shortcut menu. Then, select destination database and type a new object name. If the selected object is a table, you can copy data from it or create an empty table copy.

Note that if you copy a table with foreign key constraints, these constraints will not be copied because there may be no referenced tables in the target database.

You can copy objects of following types:

• Tables
• Views
• Stored procedures and functions