Help For Menu Items

The user iterface of goat consists of the following top-level menus. Click on the item to get more details about it :
File Menu :

The File menu consists of the following menu items :

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).
Print Ctrl + P Opens the Print Dialog to print the data in the active tab.
  • If the Data Tab is active, it will print the sql results.
  • For Properties tab, it will print the properties
  • If Relation Tab is active, it will print a view of the relation diagram, spanning multiple pages.
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 :

 

The Edit menu consists of the following menu items :

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 :

 

The Database menu consists of the following menu items :
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 :

 

The tools menu consists of the following items :
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.
Displays a drop-down list of available sql functions for the database.
Displays a drop-down list of available data types in the database.
Displays column drop-down list for the selected table.

Look And Feel   Displays various look and feel's available for your OS

 

Windows Menu :

 

The windows menu consists of the following items :

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 :

 

The help menu consists of the following items :

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.