Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How do I bind the F5 key to refresh the Object Explorer in SQL Server Management Studio?

Tags:

ssms

I was having an issue where pressing F5 when an item was highlighted in Object Explorer would launch Debug rather than refreshing the child elements of the object highlighted. I was able to make it so that F5 no longer launches Debug mode, but I am unable to find the command to bind to F5 to have Object Explorer refresh the child elements of the node. Does anyone know how I can go about doing this? I would appreciate any advice that anyone can provide.

like image 846
user1202747 Avatar asked Oct 03 '12 03:10

user1202747


People also ask

How do you refresh an Object Explorer in SQL Server?

Press F8 to make the Object Explorer active then press F5 (in this case it will work as Refresh, not as Execute query if you are in the Object Explorer).

How do I pin an object Explorer in SQL Server Management Studio?

Just open SQL server management studio. On the menu bar, select Window, then Reset Window Layout. This will place object explorer to its original position.

What does Ctrl F5 do in SQL?

CTRL + F5: Parse the query to check if there are any syntax errors. CTRL + ALT + P: Open up SQL Server Profiler. Profiler is generally used for tracing and analysing. ALT + F1 (Select any stored procedure on query editor and press ALT + F1) : It runs the sp_help system stored procedure.

How do I enable keyboard shortcuts in SSMS?

SQL Server Management Studio (SSMS) offers keyboard shortcuts. By default, it uses the SQL Server scheme, with keyboard shortcuts based on Visual Studio. To change the keyboard scheme or add more keyboard shortcuts, on the Tools menu, select Options. Select the desired keyboard scheme on the Environment, Keyboard page.


1 Answers

I figured it out.

The command to bind F5 to is View.Refresh. The area of the software should be "Global".

Alternatively, resetting the keyboard shortcuts to the default worked for me.

like image 121
user1202747 Avatar answered Oct 21 '22 01:10

user1202747