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. |