Online Documentation for SQL Manager for InterBase/Firebird

SQL Assistant


SQL Assistant which is located at the bottom of the Database Explorer window helps you to work with your database objects. Depending on the current selection in DB Explorer, the SQL Assistant area displays additional information pertaining to the selected object.

 

DB Explorer - SQL Assistant

 
 
If you select a database in DB Explorer, SQL Assistant displays the list of the database object groups and the number of objects in each group.

 

Selecting an object group in DB Explorer displays the list of the objects in SQL Assistant. Double-clicking the object name in SQL Assistant makes the object available for editing in the appropriate editor. The context menu of the object or group of objects (selected with the Ctrl or Shift keys pressed) allows you to edit or drop the selected objects.
 
If you select a table or a view in DB Explorer, SQL Assistant displays the list of the table subobjects (e.g. fields and their types) by default. What is displayed in SQL Assistant when a table or a view is selected in DB Explorer depends on the Table Details / View Details selection. Click the View Mode btnViewMode toolbar button and select the Table Details | Show... (or View Details | Show...) drop-down menu item, or use the context menu of SQL Assistant. Possible values are: Show Fields, Show Primary Keys, Show Uniques, Show Foreign Keys, Show Checks, Show Indexes, Show Triggers, Show DDL, Show Description (for tables); Show Fields, Show Triggers, Show DDL, Show Description (for views).
 

If you select a procedure or a user-defined function in DB Explorer, SQL Assistant lists its parameters by default. Use the Procedure Details / UDF Details | Show... context menu item within the SQL Assistant area to define the content of SQL Assistant when a procedure or a user-defined function is selected in DB Explorer. Possible values are: Show Parameters, Show DDL, Show Description (for procedures); Show Arguments, Show DDL, Show Description (for UDFs).

 

If you select an exception in DB Explorer, SQL Assistant lists its text by default. Use the Exception Details context menu item within the SQL Assistant area to define the content of SQL Assistant when an exception is selected in DB Explorer. Possible values are: Show Text, Show DDL, Show Description.

 

If you select a generator in DB Explorer, SQL Assistant lists its value by default. Use the Generator Details context menu item within the SQL Assistant area to define the content of SQL Assistant when a generator is selected in DB Explorer. Possible values are: Show Value, Show DDL.

 

Selecting other objects in DB Explorer displays the DDL definition in SQL Assistant by default. Use the Other Objects' Details | Show... context menu item within the SQL Assistant area to define the content of SQL Assistant when an object is selected in DB Explorer. Possible values are: Show DDL, Show Description.

 

DB Explorer - SQL Assistant - Object details

 

 

You can also use SQL Assistant to work with your queries quickly. You can drag-and-drop object aliases to the Query Editor, Query Designer or Execute Script Editor working area, in the same way as this operation is performed in Database Explorer.