| File Menu | ||
| Name | Shortcut | Description |
| New Connection | Ctrl + N | Opens the Edit Connections dialog, to allow users to create a new database connection. |
| Open | Ctrl + O | Allows user to open a text file (*.sql) to execute multiple SQL statements. |
| Save | Ctrl + S | Saves the query in the data tab to a text file (*.sql). |
| Ctrl + P |
Opens the Print Dialog to print the data in the active tab.
|
|
| Export | Opens the Export Dialog to export the results to a user-specified file. | |
| Import | Opens the Import Dialog to allow users to import text data into a table. | |
| Import Mappings | Opens the Import Mappings Dialog to allow users to create import mappings to control the way a table schema is created during schema import. | |
| Exit | Ctrl + Q | Closes all active connections, and exits to the operating system. |
Edit Menu :
| Edit Menu | ||
| Name | Shortcut | Description |
| Undo | Ctrl + Z | Undo's the text typed in the data Tab. |
| Redo | Ctrl + Y | Redo's the text typed in the Data Tab. |
| Cut | Ctrl + X | Cut's the text into the clipbard. |
| Copy | Ctrl + C | Copies the text into the clipboard. |
| Paste | Ctrl + V | Pastes the text into the clipboard. |
| Find | Ctrl + F | Opens the Find Dialog to find matching data in the result tab. |
Database Menu :
| Database Menu | ||
| Name | Shortcut | Description |
| Connect | F9 | Opens the Connect Dialog to connect to a specific database |
| Re-Connect | Ctrl + F9 | Reconnects to the existing database. Useful if database connection has become invalid. |
| Execute Query | F5 | Executes the query typed in the text pane of Data Tab. Multiple queries can also be executed if they are separated with the semi-colon (;) character |
| Execute Tabbed Query | Ctrl + F5 | Executes all queries specified in the text pane of Data tab. Displays the results in a tabbed format. The Tabbed Query Mode page contains more information about this feature. |
| Set Autocommit | Sets the auto-commit mode of the database on or off. | |
| Create Table | F4 | Opens the Create Table dialog to allow users creating a table. |
| Update Data | F2 | Opens the Update Data dialog to update table row data. |
| Properties | F12 | Displays the database properties dialog. |
Tools Menu :
| Tools Menu | ||
| Name | Shortcut | Description |
| AutoConnect | Remembers the opened connections when user exits goat. So the next time when goat is started, it will connect automatically to all the previously opened connections. | |
| Edit Connections | Ctrl + E | Opens the Edit Connections dialog to create/edit database connections. |
| Load Drivers | Ctrl + L | Allows users to dynamically load JDBC drivers into memory through the Load Driver dialog. |
| Smart Query Mode | Ctrl + M | Toggles the Smart Query Mode on or off. |
| Query Completion |
Ctrl + Alt + T Ctrl + Alt + F Ctrl + Alt + D Ctrl + Alt + C |
Query completion provides code style completion when typing SQL Queries. It has the following options :
Displays a drop-down list of tables in the current schema. |
| Look And Feel | Displays various look and feel's available for your OS | |
Windows Menu :
| Windows Menu | ||
| Name | Shortcut | Description |
| Close | This submenu contains a list of opened database connection, you can close the one by selecting it from here. | |
| <Database List> | Lists all the database connections. Switch to a different one by selecting that database. | |
Help Menu :
| Help Menu | ||
| Name | Shortcut | Description |
| Contents | Displays the help for the application. | |
| Help By Menus | Displays help for all the menu items. | |
| Dialogs | Displays help for all the dialogs in the application. | |
| Register | Takes user to the registration site to purchase goat. | |
| About | Displays the version and registration information. | |