.. raw:: latex

  \appendix

  \titleformat{\section}
  {\huge\color{red}}
  {\thesection}{1em}{}

  \titleformat{\subsection}
  {\LARGE\color{red}}
  {\thesubsection}{1em}{}

  \renewcommand{\thetable}{\Alph{application}.\arabic{table}} % нумерация таблиц с номером section

  \renewcommand{\thefigure}{\Alph{application}.\arabic{figure}}

  \renewcommand{\thesubsection}{\Alph{application}.\arabic{subsection}} % нумерация подразделов типа F.1

  \renewcommand{\theredlisting}{\Alph{application}.\arabic{redlisting}}

  \appcount

.. _toolbar:

Toolbar
==========================

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

.. tabularcolumns:: |>{\center}\X{3}{17}|>{\ttfamily\arraybackslash}\X{9}{17}|>{\ttfamily\arraybackslash}\X{5}{17}|
.. list-table:: Toolbar
   :class: longtable
   :header-rows: 1

   * - 
     - Description
     - Shortcuts
   * - 
       .. image:: img/icon_tree_show.png
          :scale: 15%
     - Hide/display the connection tree.
     -  
   * - 
       .. image:: img/icon_connection.png
          :scale: 15%
     - Connection to selected database.
     -  
   * - 
       .. image:: img/icon_connection_all.png
          :scale: 15%
     - Connect to all databases that are added to the connection tree.
     - 
   * - 
       .. image:: img/icon_refresh.png
          :scale: 15%
     - Refresh all objects in current connection.    
     - 
   * - 
       .. image:: img/icon_zoom.png
          :scale: 15%
     - Search object in connection tree in established connection.
     - Ctrl + F
   * - 
       .. image:: img/icon_connection_new.png
          :scale: 15%
     - Create new connection.
     - Ctrl + Shift + N
   * - 
       .. image:: img/icon_create_db.png
          :scale: 15%
     - Create database.
     - 
   * - 
       .. image:: img/icon_execute_script.png
          :scale: 15%
     - Execute SQL script from file.
     - 
   * - 
       .. image:: img/icon_compare_db.png
          :scale: 15%
     - Open a database metadata comparison tool.
     - 
   * - 
       .. image:: img/icon_create_script.png
          :scale: 15%
     - Open tool for extracting metadata into a script.
     - 
   * - 
       .. image:: img/icon_query_editor.png
          :scale: 15%
     - Open query editor.
     - 
   * - 
       .. image:: img/icon_erd_panel.png
          :scale: 15%
     - Open ER diagram editor.
     - 
   * - 
       .. image:: img/icon_db_statistic.png
          :scale: 15%
     - Open database statistics collection tool.
     - 
   * - 
       .. image:: img/icon_manager_trace.png
          :scale: 15%
     - Open trace manager.
     - 
   * - 
       .. image:: img/icon_manager_user.png
          :scale: 15%
     - Open user manager.
     - 
   * - 
       .. image:: img/icon_manager_grant.png
          :scale: 15%
     - Open grant manager.
     - 
   * - 
       .. image:: img/icon_execute_profiler.png
          :scale: 15%
     - Open profiler.
     - 
   * - 
       .. image:: img/icon_table_validation.png
          :scale: 15%
     - Open table validation tool.
     - 
   * - 
       .. image:: img/icon_import_file.png
          :scale: 15%
     - Open data import tool.
     - 
   * - 
       .. image:: img/icon_generator.png
          :scale: 15%
     - Open test data generator.
     - 
   * - 
       .. image:: img/icon_console_system.png
          :scale: 15%
     - Open system console.
     - 
   * - 
       .. image:: img/icon_application_log.png
          :scale: 15%
     - View system log.
     - 
   * - 
       .. image:: img/icon_preferences.png
          :scale: 15%
     - Open application settings.
     - 
   * - 
       .. image:: img/icon_help.png
          :scale: 15%
     - Open documentation.
     - 

Query editor toolbar
----------------------------------------------

.. tabularcolumns:: |>{\center\arraybackslash}\X{3}{17}|>{\ttfamily\arraybackslash}\X{9}{17}|>{\ttfamily\arraybackslash}\X{5}{17}|
.. list-table:: Query editor toolbar
   :class: longtable
   :header-rows: 1

   * - 
     - Description
     - Shortcuts
   * - 
       .. image:: img/icon_execute.png
          :scale: 15%
     - Execute SQL script.
     - F9
   * - 
       .. image:: img/icon_execute_statement.png
          :scale: 15%
     - Execute script in one query.
     - F5 
   * - 
       .. image:: img/icon_execute_profiler.png
          :scale: 15%
     - Execute SQL script in the profiler.
     - Shift + F5
   * - 
       .. image:: img/icon_execute_stop.png
          :scale: 15%
     - Stop execution of query.
     - 
   * - 
       .. image:: img/icon_commit.png
          :scale: 15%
     - Commit transaction.
     - Ctrl + Shift + Q
   * - 
       .. image:: img/icon_rollback.png
          :scale: 15%
     - Rollback transaction.
     - Ctrl + Shift + R
   * - 
       .. image:: img/icon_auto_commit.png
          :scale: 15%
     - Switch on autocommit mode.
     - 
   * - 
       .. image:: img/icon_warning.png
          :scale: 15%
     - Stop execution of SQL script when an error occurs.
     - 
   * - 
       .. image:: img/icon_execute_to_file.png
          :scale: 15%
     - Export query result to file.
     - 
   * - 
       .. image:: img/icon_limit_row_count.png
          :scale: 15%
     - Limit number of input rows.
     - 
   * - 
       .. image:: img/icon_bookmarks.png
          :scale: 15%
     - Managing query bookmarks.
     - Ctrl + B
   * - 
       .. image:: img/icon_history.png
          :scale: 15%
     - Open query execution history.
     - Ctrl + Shift + H
   * - 
       .. image:: img/icon_move_previous.png
          :scale: 15%
     - Enter previously executed query in editor.
     - Ctrl + Shift + Down
   * - 
       .. image:: img/icon_move_next.png
          :scale: 15%
     - Enter next query in editor.
     - Ctrl + Shift + Up
   * - 
       .. image:: img/icon_export_file.png
          :scale: 15%
     - Export selected dataset to file.
     - 
   * - 
       .. image:: img/icon_rs_metadata.png
          :scale: 15%
     - Show metadata of current result set.
     - 
   * - 
       .. image:: img/icon_filter.png
          :scale: 15%
     - Add filters for current result set.
     - 
   * - 
       .. image:: img/icon_print_plan.png
          :scale: 15%
     - Show query plan.
     - Ctrl + Shift + P
   * - 
       .. image:: img/icon_toggle_transaction_parameters.png
          :scale: 15%
     - Show transaction parameters.
     - 
   * - 
       .. image:: img/icon_toggle_editor_output.png
          :scale: 15%
     - Display results output panel.
     - Ctrl + E
   * - 
       .. image:: img/icon_toggle_split.png
          :scale: 15%
     - Change separator orientation.
     - Ctrl + Alt + Q

ER-diagram editor toolbar
-----------------------------------------------

.. tabularcolumns:: |>{\center\arraybackslash}\X{3}{17}|>{\ttfamily\arraybackslash}\X{9}{17}|>{\arraybackslash}\X{5}{17}|
.. list-table:: ER-diagram editor toolbar
   :class: longtable
   :header-rows: 1

   * - 
     - Description
     - Shortcuts
   * - 
       .. image:: img/icon_table_add.png
          :scale: 15%
     - Create table.
     - 
   * - 
       .. image:: img/icon_table_drop.png
          :scale: 15%
     - Delete selected object.
     - 
   * - 
       .. image:: img/icon_erd_relation_add.png
          :scale: 15%
     - Add relation.
     - 
   * - 
       .. image:: img/icon_erd_relation_delete.png
          :scale: 15%
     - Delete relation between selected objects.
     - 
   * - 
       .. image:: img/icon_create_script.png
          :scale: 15%
     - Generate SQL script to create objects from diagram.
     - 
   * - 
       .. image:: img/icon_refresh_connection.png
          :scale: 15%
     - Build ER-diagram of existing database.
     - 
   * - 
       .. image:: img/icon_comment.png
          :scale: 15%
     - Add text block.
     - 
   * - 
       .. image:: img/icon_title.png
          :scale: 15%
     - Add header for diagram.
     - 
   * - 
       .. image:: img/icon_style_font.png
          :scale: 15%
     - Open font settings.
     - 
   * - 
       .. image:: img/icon_style_line.png
          :scale: 15%
     - Open line settings.
     - 
   * - 
       .. image:: img/icon_foreground.png
          :scale: 15%
     - Change colour of selected object.
     - 
   * - 
       .. image:: img/icon_background.png
          :scale: 15%
     - Change background colour of diagram.
     - 
   * - 
       .. image:: img/icon_zoom_out.png
          :scale: 15%
     - Zoom out.
     - 
   * - 
       .. image:: img/icon_zoom_in.png
          :scale: 15%
     - Zoom in.
     - 