If you click on a database, a list of tables in that database is displayed. Clicking on a table will display the DDL for that table:
Selecting the menu item "View|Toggle DDL/data", or the third button on the toolbar, will display the contents of that table. (Warning: data is loaded in one go - if the table is very large, the GUI may appear to hang while data is being retrieved from the database). Note the popup menu - right-clicking in the grid will bring up this menu. It allows easy copying of table data to the clipboard. Column data is tab-separated, and can be pasted directly into gnumeric or Excel. Data can also be copied to the clipboard by selecting a range with the mouse.
The count column function on the popup menu will count the occurrences of each unique value in a column. Switch to vertical mode will switch columns and rows, causing the column headers to appear as data items in the first column, the first row of data will be in the second column, the second row in the third column etc. This is useful when looking at a small number of rows in a table with many columns.
Right-click on a table name in the list of tables for various ways of selecting and modifying table data:
For example, clicking on "Query" will bring up the dialog shown below. Queries (and Updates etc.) are remembered for each tablename, so it is easy to run the same query against the same table in multiple databases (e.g. development and production databases). The "Truncate" and "Drop table" options both have confirmation dialogs. The "Execute SQL" option allows arbitrary SQL to be executed (also available by clicking on the SQL icon on the toolbar). Results are displayed in the grid. A history is kept, so SQL can be re-run.
As well as dealing with tables, Sybesque allows browsing of, and execution of, stored procedures. Select "Stored procedures" from the drop-down at the top of the dialog and a list of stored procedures in the current database will be displayed. Select a stored procedure and its text will be displayed:
Right-click on a stored procedure and select "Execute with params" and a dialog will pop up with space to enter each stored procedure parameter. Click "Execute" on the dialog to run the stored procedure - any results will be displayed in the grid, and the return status will be displayed on the status line:
Right-clicking on a database will show a popup menu that allows various parts of the database to be saved to disk. The DDL for every table in the database can be saved to disk, either as one file per table, or one big file. The text for every stored procedure or trigger can be similarly saved. In addition, the option "Dump table data to directory" will bcp out the data in every table in the database.