meta data for this page
  •  

IBExpert keyboard shortcuts

Main form

Register Database [Shift]+[Alt]+[R]
Unregister Database [Shift]+[Alt]+[U]
Connect to Database [Shift]+[Ctrl]+[C]
Disconnect from Database [Shift]+[Ctrl]+[D] (No effect)
SQL Editor [F12]
New SQL Editor [Shift]+[F12]
SQL Monitor [Ctrl]+[M]
Search in Metadata [Shift]+[Alt]+[F]
Windows Manager [Alt]+[0}
Create User Item from Clipboard [Ctrl]+[V]
Copy User Item to Clipboard [Ctrl]+[C]
Find [Ctrl]+[F]
Replace [Ctrl]+[R]
Search Again [F3]
Incremental Search [Ctrl]+[E]
Delete [Ctrl]+[Del] (No effect)
DB Explorer [F11]
Perfect layout [Ctrl]+[F3] (No effect)
Apply best fit [Ctrl]+[Num] (No effect)
New Subfolder [Shift]+[Ctrl]+[S] (No effect)
Show SQL Assistant [Ctrl]+[A]
Visual Query Builder [Ctrl]+[Alt]+[B] (No effect)
Select Database [Shift]+[Ctrl]+[D] (No effect)

Database Explorer

New Folder [Shift]+[Ctrl]+[F] ([CTRL]+[N]) ??
Delete Folder [Del] ([CTRL]+[Del]) ??
Show SQL Assistant [Ctrl]+[A]
Jump to domains [Ctrl]+[Alt]+[D]
Tables [Ctrl]+[Alt]+[T]
Views [Ctrl]+[Alt]+[V]
Triggers [Ctrl]+[Alt]+[R]
Procedures [Ctrl]+[Alt]+[P]
Generators [Ctrl]+[Alt]+[G]
UDFs [Ctrl]+[Alt]+[U]
Packages [Ctrl]+[Alt]+[K]
Functions [Ctrl]+[Alt]+[F]

SQL Editor

Tables [Ctrl]+[Alt]+[T]
Go to [Alt]+[G]
Cut [Ctrl]+[X]
Copy [Ctrl]+[C]
Select All [Ctrl]+[A]
Commit Transaction [Ctrl]+[Alt]+[C]
Rollback Transaction [Ctrl]+[Alt]+[R]
Export Data [Ctrl]+[E]
Print Table Metadata [Shift]+[Ctrl]+[P]
Previous Query [Ctrl]+[P]
Next Query [Ctrl]+[N]
Delete [Shift]+[Del] ??
Navigate brackets [Shift]+[Ctrl]+[5]
(No opening bracket found, it worked in previous build IIRC)
Toggle case [Shift]+[F3]
Convert to uppercase [Alt]+[Up]
Convert to lowercase [Alt]+[Down]
Execute and fetch all [Shift]+[F9]
Count records [Shift]+[F6]
Clear All History [Shift]+[Ctrl]+[Del] (No effect)
Format query text [Alt]+[F]
Execute current query [Shift]+[Ctrl]+[F9]
Prepare Query [Ctrl]+[F9]
New Query [Shift]+[Ctrl]+[N]
Delete Query [Ctrl]+[D]
Export Data [Ctrl]+[E]
Rename Query [Ctrl]+[F2]
Save to file [Ctrl]+[S]
Load from file [Ctrl]+[L]
List of Domains [Ctrl]+[Alt]+[D]
List of Exceptions [Ctrl]+[Alt]+[E]
List of Fields [Ctrl]+[Alt]+[F]
List of Generators [Ctrl]+[Alt]+[G]
List of Procedure Variables [Ctrl]+[Alt]+[L]
List of Procedures [Ctrl]+[Alt]+[P]
List of SQL Keywords [Ctrl]+[Alt]+[S]
List of Procedure Parameters [Ctrl]+[Alt]+[M] (Not working)
List of Tables [Ctrl]+[Alt]+[T]
List of UDFs [Ctrl]+[Alt]+[U]
List of Views [Ctrl]+[Alt]+[V]
Comment Selected [Shift]+[Alt]+[C]
Uncomment Selected [Shift]+[Alt]+[U]
(Runs Unregister Database)

Functions Editor

Compile function [Ctrl]+[F9]
Execute function [F9]
Debug function [Shift]+[Ctrl]+[D]

To Do List

Refresh ToDo list [F5]

General

Exit [Alt]+[F4]
Compile [F9]
Edit [F2]
Delete [Del]
Undo [Ctrl]+[Z]
Undo all [Shift]+[Ctrl]+[Z]
Script Executive [Ctrl]+[F12]
Incremental Search [Ctrl]+[F] (there is one already , main form)
Execute [F9]
Drop object [Ctrl]+[Del]
Refresh [F5]
Run [F9]
Save [F2] (what about edit [F2]?)
Copy to clipboard [Shift]+[Ctrl]+[C]
Paste from clipboard [Shift]+[Ctrl]+[V]
Format code [Alt]+[F]
Show data [F9] (couldn’t find where it is)
Find Item [Ctrl]+[F]
Edit Item [F2]
Show Toolbar [Ctrl]+[T] (couldn’t find where it is)
Show Snippets Page [Ctrl]+S (couldn’t fine where it is)
Commit Transaction [Ctrl]+[Alt]+[C]
Rollback Transaction [Ctrl]+[Alt]+[R]
Execute [F9]
[Delete All [Shift]+[Ctrl]+[D] (couldn’t find where it is)
Go to [Alt]+[G]
Save Description [F2] (no effect, Save [F2], Edit [F2])

Extract Metadata

Start Extract - [F9]
Extract to [Shift]+[Ctrl]+[T]

Data Tab

Adjust column widths [Ctrl]+[Num] *
Display data as Unicode [F3]

Debugger

Toggle breakpoint [F5]
Step Over [F8]
Reset [Ctrl]+[F2]
Parameters [Shift]+[Ctrl]+[P]
Trace Into [F7]
Run to Cursor [F4]

Grant Manager

Save into New File [Ctrl]+[S]
Append to Existing File [Shift]+[Ctrl]+[S]

Table Editor

Add field [Ins]
Edit Table Structure [F2]
Print Table Metadata [Shift]+[Ctrl]+[P]

Trigger Editor

Compile Trigger [Ctrl]+[F9]

Stored Procedure Editor

Debug procedure [Shift]+[Ctrl]+[D]
Compile procedure [Ctrl]+[F9]
Execute procedure [F9]

View Editor

Compile view [Ctrl]+[F9]

Script Editor

Run from file [Shift]+[F9]
Run Script [F9]

Backup/restore database (IBEBlock)

Open block in Script Executive (and close this window) [Ctrl]+[F12]

Version History

Delete version [Del]
Remove duplicates [Shift]+[Ctrl]+[Del]

Dependency Viewer

Expand Recursive [Ctrl]+[Right]
Collapse Recursive [Ctrl]+[Left]
Remove Node [Ctrl]+[Del]
Drop object [Ctrl]+[Del]
Show domains [Ctrl]+[D]
Show tables [Ctrl]+[T]
Show views [Ctrl]+[V]
Show triggers [Ctrl]+[R]
Show procedures [Ctrl]+[P]
Show exceptions [Ctrl]+[E]
Show generators [Ctrl]+[G]
Show UDFs [Ctrl]+[U]
Show functions [Ctrl]+[F]
Show packages [Ctrl]+[K]

Report Manager

Open report from file [Ctrl]+[O]
Design report [Ctrl]+[D] (not working)

Unknown

New Snippet [Ins]
Compile [Ctrl]+[F9]
Delete Snippet/Folder [Shift]+[Del]
Create Snippet from Clipboard [Ctrl]+[V]
Copy Snippet to Clipboard [Ctrl]+[C]
Autogrant privileges [Ctrl]+[F8]
Autogrant privileges [Shift]+[Ctrl]+[A]
Add New Criteria [Ins]
Delete Criteria [Ctrl]+[Del]
Apply Filter [Ctrl]+[Alt]+[A]
Show Filter Panel [Ctrl]+[Alt]+[F]
Copy Text as RTF [Ctrl]+[W]
Load configuration [Ctrl]+[L]
Save configuration [Ctrl]+[S]
Autogrant privileges [Ctrl]+[F8]
Save Description [Ctrl]+[S]
Compare [F9]
Display exception text as unicode [F3]
Pause [Ctrl]+[P]