Questions tagged [keyboard-shortcuts]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1
vote
0answers
19 views

SSMS - Can I create a default layout?

Using SSMS 11 to connect to a SQL Server 2012 instance. When I first load up SSMS and log-in, is it possible to have specific nodes in the object explorer expand? I always expand the tables node in ...
0
votes
0answers
143 views

“New query window” shortcut for Oracle SQL Developer

I'm used to Ctrl-N to give me a new query window in SSMS. How do I do it in Oracle?
2
votes
1answer
158 views

Shortcut to select all SQL text in Access

When working in the SQL view in MS Access, is there a shortcut to select all the text in a SQL query. For example, most text editors in Windows follow the {Ctrl+ a} combination, but this doesn't seem ...
1
vote
0answers
261 views

Shortcut for Applying stored procedures in MySQL Workbench

Using MySQL Workbench, after editing a stored procedure in the built-in editor, the only way I know how to commit the changes are to take my hands off the keyboard, use the mouse, and click "Apply", ...
1
vote
2answers
1k views

SSMS shortcut to comment/uncomment a specific part of the query?

I'm looking for an option to comment/uncomment a particular part of the query with the Slash Star Comment option. Scenario: While debugging the queries with N numbers of JOINs, I comment out each ...
1
vote
1answer
282 views

Microsoft sql server management studio (SSMS) shortcut for changing size of sql/result panes

In the good old days there was a shortcut ctrl-B for changing the size of the Query & Result panes in the Query Analyzer sql editor. In Query Analyzer, just press ctrl-B and the screen splitter ...
7
votes
2answers
3k views

Keyboard shortcut to execute statement at cursor in pgAdmin

In MySQL Workbench, one can use the keyboard shortcut Ctrl + ENTER to execute the statement at cursor (delineated with semi colons). Is there a similar shortcut in pgAdmin? For SQL queries that span ...
2
votes
1answer
95 views

Shortcut for deleting a line of SQL

Is there a shortcut to delete your current line of SQL without highlighting the full line? I want to delete the line that my cursor is on without selecting the whole line. So in visual studio CTRL + ...
2
votes
2answers
2k views

How do I add keyboard shortcuts in SSMS 2012 to run a specific query?

How do I add keyboard shortcuts in SSMS 2012 to select all the data from table? In SSMS 2008 we could assign a shortcut in the following way: TOOLS-->OPTIONS-->ENVIRONMENT-->KEYBOARD--->CTRL+3-->...
3
votes
1answer
2k views

Ctrl-F1 shortcut stopped working in SSMS 2014

I've had the Ctrl-F1 query shortcut bound to sp_whoisactive for years (this technique is described in How to assign CTRL+F1 to sp_whoisactive in ssms 2012?). A few days ago, it stopped working. If I ...