Questions tagged [keyboard-shortcuts]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
2
votes
1answer
76 views

About Apex SQL Refactor and SSMS keyboard shortcuts being broken

Hi DBA Stack Exchange! Today I tried Apex SQL Refactor and right from the get go, once installed and integrated into my T-SQL dev tool of Choice (SSMS 18.3.1) I noticed that some Keyboard shortcuts ...
0
votes
0answers
50 views

SSMS How to Click within Query to Open Table

I come from oracle SQL Developer world where I can ctrl+click on a table name within a query and the table definition automatically opens. This is great as it alleviates my need to navigate within ...
1
vote
0answers
20 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 ...
1
vote
1answer
800 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
176 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
320 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
2k 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
324 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 ...
8
votes
2answers
4k 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
124 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
3k 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 ...