You are in: Products > HoneyMonitor > Reference Manual > On-line Consultation >

41.4 Table Editor

The Table Editor is the tool that HoneyMonitor gives you to manage a table; using the Table Editor you can ''open'' a table and with few clicks see and manage its columns, indexes, foreign keys, triggers, partitions, data and its properties. Also all the tools you need for a complete administration of a table can be open from the Table Editor included the creation of fine reports. So, for example, to edit a Field just go to the fields Tab of the Editor, find the field in the fields grid and double click on its row: the Field Editor (sec. 41.5.1) will appear and you are ready to edit the field.

To open the''Editor'' (Fig. 41.26) use the popup menu of the ''Server Objects List'' (see the introduction of the chap. 41).

See Also:

42.1: Views Editor
43.1: Stored Procedures Editor
44.1: Stored Functions Editor
45.1: Scheduled Events Editor

**Figure 41.26:** The Table Editor.

The Editor is divided into several Tabs each associate to a sub-table object. Each Tab has a own toolbar to call the features involving that Tab. Also the grids contained in some of the Tabs have useful popup menu.

A main toolbar can be used from all the Tabs.

You may open as many Table Editor as you want to do a comparison between more tables (of the same or of a different database or server).

Toolbar
Using the main toolbar you may:

refresh the ''Editor'';
create a new table;
create a HTML report;
create a report;
view the help;
close the ''Editor'';

41.4.1 Fields Tab

The Fields Tab allows you to manage table's fields. For each field its main properties are listed in the grid (Fig. 41.27).

To add, edit or drop a field you may use Tab's toolbar or the grid's popup menu.

Further information about Fields can be found in the sec. 41.5.

See Also:

76.2: Look and Feel

**Figure 41.27:** Table's Structure.

41.4.2 Indexes Tab

The Indexes Tab allows you to manage the table's indexes. For each index its main properties are listed in the grid (Fig. 41.28).

To add or drop an index you may use the Tab's toolbar or the grid's popup menu.

Further information about Indexes can be found in the sec. 41.6.

**Figure 41.28:** Table's Indexes.

41.4.3 Foreign Keys Tab

The Foreign Keys Tab allows you to manage the table's foreign keys. For each key its main properties are listed in the grid (Fig. 41.29).

To add, edit or drop a key you may use the Tab's toolbar or the grid's popup menu.

Further information about Foreign Keys can be found in the sec. 41.7.

Note: This Tab is enabled for InnoDB tables only.

**Figure 41.29:** Table's Foreign Keys.

41.4.4 Triggers Tab

The Triggers Tab allows you to manage table's triggers. For each trigger its main properties are listed in the grid (Fig. 41.30).

To create, edit or drop a trigger you may use the Tab's toolbar or the grid's popup menu.

Further information about Triggers can be found in the sec. 41.8.

Note: the support for the Triggers was added in MySQL^TM v.5.0.2; if the version of the server you are connected to is lesser than 5.0.2 this Tab is disabled.

**Figure 41.30:** Table's Triggers.

41.4.5 Partitions Tab

The Partitions Tab allows you to manage table's partitions. If the table is partitioned, for each partition its main properties are listed in the grid (Fig. 41.31).

To create, edit or drop a partition use the Tab's toolbar or the grid's popup menu.

Further information about Partitions can be found in the sec. 41.9.

Note: the support for the Partitions was added in MySQL^TM v.5.1; if the version of the server you are connected to is lesser than 5.1 this Tab is disabled.

**Figure 41.31:** Table's Partitions.

41.4.6 Data Tab

The Data Tab (Fig. 41.32) allows you to see / edit the table's records.

Please, refer to chap. 23 for a description of the Records Viewer.

**Figure 41.32:** Table's Records.

41.4.7 Information Tab

The information Tab allows you to manage table's properties (Fig. 41.33).

To edit the table's properties use the Tab's toolbar or the grid's popup menu.

Further information about Table Properties can be found in the sec. 41.2.

**Figure 41.33:** Table Information.

41.4.8 SQL Tab

The SQL Tab (Fig. 41.34) contains the SQL syntax for recreating the table. The code control is not editable: please use the other Tabs to edit the table.

If you right click a useful popup menu will appear.