=========================
SQLyog raccourcis clavier
=========================

Publié pour la première fois le 05/06/2019 sur
https://defkey.com/fr/sqlyog-raccourcis-clavier


SQLyog a 93 raccourcis et nous les avons énumérés ci-dessous.



Connection
----------

Ctrl + M                Create A New Connection
Ctrl + N                Create A New Connection With Current Connection Properties
Ctrl + F4               Disconnect The Current Connection
Ctrl + W                Disconnect The Current Connection
Ctrl + Tab              Switch to Next Connection
Ctrl + Maj + Tab        Switch to Previous Connection
Ctrl + 1                … to Ctrl + 8: Select Connection (1 to 8)
Ctrl + 9                Select Last Connection


Object Browser
--------------

F5                      Refresh Object Browser (Default)
Ctrl + B                Set Focus On Object Browser
Ctrl + Maj + B          Set Focus On Object Browser Filter
Maj + -                 Collapse All in Object Browser


SQL Window
----------

Ctrl + T                New Query Editor
Alt + F2                Rename Query Editor
Ctrl + E                Set Focus On SQL Window
Ctrl + Y                Redo
Ctrl + Z                Undo
Ctrl + X                Cut
Ctrl + V                Paste
Ctrl + H                Replace
Ctrl + G                Go to
Ctrl + O                Open File In New Tab
Ctrl + Maj + O          Open File In Same Tab
Ctrl + Maj + U          Make Selection Uppercase
Ctrl + Maj + L          Make Selection Lowercase
Ctrl + Maj + C          Comment Selection In SQL Window
Ctrl + Maj + R          Remove Comment From Selection
Ctrl + Maj + T          Insert Templates
Ctrl + Entrée           List All Tags
Ctrl + Espace           List Matching Tags


Query Execution
---------------

F8                      Execute Current Query And Edit Result
F9                      Execute Current Query (Default)
Ctrl + F9               Execute Selected Query(s) (Default)


SQL Formatter
-------------

F12                     Format Current Query
Ctrl + F12              Format Selected Query
Maj + F12               Format All Queries


Paste SQL Statements
--------------------

Alt + Maj + I           Insert Statement
Alt + Maj + U           Update Statement
Alt + Maj + D           Delete Statement
Alt + Maj + S           Select Statement


Result
------

F11                     Insert Update Dialog
Ctrl + R                Set Focus To The Active Tab In Result Pane
Ctrl + L                Switch Result Window/Table Data Between Grid/Text Mode or Form View/text
Ctrl + Alt + L          Switch Result Window/Table Data Between Grid and Form View
Ctrl + Alt + C          Export Table Data As CSV, Excel, SQL etc...
Ctrl + Alt + E          Backup Data As SQL Dump
Ctrl + Maj + M          Import Data From CSV
Ctrl + Maj + E          Export Resultset
Alt + 1                 …to Alt + 8: Select Tab In Result Window (1 to 8)
Alt + 9                 Select Last Tab in the Result Window


Show/Hide
---------

Ctrl + Maj + 1          Show/Hide Object Browser
Ctrl + Maj + 2          Show/Hide Result Pane
Ctrl + Maj + 3          Show/Hide Query Window


Database/Table
--------------

Ctrl + D                Create Database
F6                      Alter Database/Table Structure/Index/View/Store Proc/Function/Trigger/Event
F2                      Rename Table/View/Trigger/Event
Maj + Suppr             Truncate Database/Table
F7                      Manage Index Window
F10                     Relationships/Foreign Keys
Ctrl + Alt + R          Reorder Column(s)
Alt + S                 Save Table
Alt + R                 Revert Changes Made To Table Schema
Ctrl + Alt + T          Table Diagnostics
Ctrl + Alt + F          Flush Dialog
Ctrl + Maj + Alt + S    Create Schema For Database In HTML
Ctrl + Maj + Q          Restore From SQL Dump


PowerTools
----------

Ctrl + Alt + W          Database Synchronization Tool
Ctrl + Q                Schema Synchronization Tool
Ctrl + Alt + O          Migration Toolkit
Ctrl + Alt + N          SQL Scheduler and Reporting Tool
Ctrl + Alt + S          Scheduled Backup Wizard


Other Tabs
----------

Ctrl + K                Query Builder
Ctrl + Alt + D          Schema Designer
Ctrl + Maj + D          Data Search
Ctrl + Maj + I          Info Tab
Ctrl + Maj + H          History Tab


User Manager
------------

Ctrl + U                Add A New User
Ctrl + Alt + U          Edit User
Ctrl + Maj + W          Manage Privileges


Favorites
---------

Ctrl + Maj + F          Add Current SQL To Favorites


Language
--------

Alt + Maj + L           Change Language


Other
-----

F1                      Help
Ctrl + C                Copy
Ctrl + A                Select All
Ctrl + F                Find (SQL Window/Result Window And Table Data In Text Mode/Blob Viewer)
F3                      Find Next (SQL Window/Result Window And Table Data In Text Mode)
Ctrl + S                Save
Ctrl + Pg Préc          Switch To Previous Tab
Ctrl + Pg Suiv          Switch To Next Tab
Suppr                   Delete Selected
Alt + F5                Refresh Table Data Tab
Alt + L                 Close Tab
Alt + F4                Exit

Source


Dernière mise à jour (UTC): lundi 11 novembre 2019
Defkey © Tous les droits sont réservés.