Can I copy a table / collection 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

Apply Navicat Version No.: Windows version 7.x or above, macOS version 6.x or above, Linux version 11.x or above

To copy tables / 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 / 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 connection / 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 / collections are not on the same server as the target database, a Data Transfer window will be shown.