Creating a Copy of a Database Object

Last modified: January 13, 2025

dbForge Studio for MySQL gives you the duplicate object feature. You can create an exact copy of a database object in the same or different database of the same or different 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 a 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. Moreover, you can drop the destination object during this process.

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
• Packages
• Sequences