Result Table
 

This section describes all you need to know about the result table. This includes things like


Context Menu

Copy to Clipboard Copies the contents of currently selected table cells to the clipboard. The contents of single cells is separate with ','.
Copy Name to Clipboard
(Header only)
Copies the name of the column to the clipboard.
Save to File... Save the content of the currently selected cell into a file. The selected cell must contain character or binary data.
Statistics Calculate statistics of all selected cells or the sum of the whole column if used on the table header. This will only work for cells containing real numbers or strings representing numbers.
JDBC Info
(Header only)
Show some JDBC related information about the column.
Show referenced row Show the record referenced by the foreign key defined for the selected cell.
Show referencing rows Show all records referencing the currently selected row as a foreign key.
Show referenced table Show the table referenced by the foreign key defined for the selected column.
Show referencing tables Show the table referencing the currently selected column as a foreign key.
Refresh Data Refreshes the table data by executing the statement again.
Auto-Refresh Data/
Stop Auto-Refresh
Allows you to specifies an interval in seconds in which the table data will be refreshed automatically. The automatic refresh will stop if an error occurs or the window is closed. The user can stop the refresh by using 'Stop Auto-Refresh' from the context menu.
Format Allows you to view the data of the specified column in a different format. For example is it possible to view numbers in their binary or hexadecimal representation. It is possible to create your column formats
Font Allows you to view the cells of the specified column in a different font.
Mark column as primary key Allows the user to specify the primary key column in the table if the plugin couldn't automatically determine them. For editing the result tables it is necessary that the table has at least one primary key.
Delete Row Delete the record represented by the selected row. For deleting rows from tables it is necessary that the table has at least one primary key.
Manage Columns... Opens a dialog which allows to hide/show columns of the result table.