Using FEDERATED Tables

FEDERATED table allows you to work with remote tables and not to store them locally.

Creating a FEDERATED Table

To create a FEDERATED table, use the database where the table is stored.

  1. Go to the Columns tab of the table editor.
  2. Select the FEDERATED storage engine type in the Engine combo box.

  3. Switch to the Federated options tab.
  4. Specify the connection string. Alternatively, to connect to the required table on the server, select the corresponding server and the table link.
  5. Now you can access to the server that store the required table through the federated table, view all changes, and work with table’s data on the remote server.

Editing a FEDERATED Table

You can edit a federated table by selecting Edit Table on the Database Explorer node shortcut menu. All the changes you make will be also shown on the server where the table is stored.

Dropping a FEDERATED Table

You can drop the federated table by selecting Delete on the Database Explorer node shortcut menu. Once the connection is broken between the running servers, you can make changes and view the result changes only on the server that stores the tables.

Note

If you have MySQL 5.0.13 installed, use COMMENT rather than CONNECTION.

Want to Find out More?

Overview

Overview

Take a quick tour to learn all about the key benefits delivered by dbForge Studio for MySQL.
All Features

All features

Get acquainted with the rich features and capabilities of the Studio in less than 5 minutes.
Request a demo

Request a demo

If you consider employing the Studio for your business, request a demo to see it in action.
Ready to start using dbForge Studio for MySQL?