20. Toolbar

Description of each toolbar and its associated buttons and actions is provided below.

Table 20.1 Toolbar

	Description	Shortcuts
	Hide/display the connection tree.
	Connection to selected database.
	Connect to all databases that are added to the connection tree.
	Refresh all objects in current connection.
	Search object in connection tree in established connection.	Ctrl + F
	Create new connection.	Ctrl + Shift + N
	Create database.
	Execute SQL script from file.
	Open a database metadata comparison tool.
	Open tool for extracting metadata into a script.
	Open query editor.
	Open ER diagram editor.
	Open database statistics collection tool.
	Open trace manager.
	Open user manager.
	Open grant manager.
	Open profiler.
	Open table validation tool.
	Open data import tool.
	Open test data generator.
	Open system console.
	View system log.
	Open application settings.
	Open documentation.

20.1. Query editor toolbar

Table 20.2 Query editor toolbar

	Description	Shortcuts
	Execute SQL script.	F9
	Execute script in one query.	F5
	Execute SQL script in the profiler.	Shift + F5
	Stop execution of query.
	Commit transaction.	Ctrl + Shift + Q
	Rollback transaction.	Ctrl + Shift + R
	Switch on autocommit mode.
	Stop execution of SQL script when an error occurs.
	Export query result to file.
	Limit number of input rows.
	Managing query bookmarks.	Ctrl + B
	Open query execution history.	Ctrl + Shift + H
	Enter previously executed query in editor.	Ctrl + Shift + Down
	Enter next query in editor.	Ctrl + Shift + Up
	Export selected dataset to file.
	Show metadata of current result set.
	Add filters for current result set.
	Show query plan.	Ctrl + Shift + P
	Show transaction parameters.
	Display results output panel.	Ctrl + E
	Change separator orientation.	Ctrl + Alt + Q

20.2. ER-diagram editor toolbar

Table 20.3 ER-diagram editor toolbar

	Description	Shortcuts
	Create table.
	Delete selected object.
	Add relation.
	Delete relation between selected objects.
	Generate SQL script to create objects from diagram.
	Build ER-diagram of existing database.
	Add text block.
	Add header for diagram.
	Open font settings.
	Open line settings.
	Change colour of selected object.
	Change background colour of diagram.
	Zoom out.
	Zoom in.