Can I copy tables or collections by drag and drop?

Apply OS: Windows, macOS, Linux

Apply Navicat Product: Navicat for MySQL, Navicat for PostgreSQL, Navicat for Oracle, Navicat for SQL Server, Navicat for MariaDB, Navicat for SQLite, Navicat for MongoDB, Navicat Premium

To copy tables or collections to the current database, you can

1. Select the tables / collections you want to copy.
2. Drop and drop them to the same object list pane.
3. To copy structure only, choose Copy Here (Structure Only). To copy structure and data, choose Copy Here (Structure and Data).

To copy tables or collections to another database, you can

1. Select the tables / collections you want to copy.
2. Drop and drop them to one database node in the navigation pane.
3. To copy structure only, choose Copy Here (Structure Only). To copy structure and data, choose Copy Here (Structure and Data).

If the source tables or collections are not on the same server as the target database, a Data Transfer window will be shown.