Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Deselect selected text in sql server management studio table-design cell w/out using mouse

This is something that has bothered me for years. When I am using SQL Server 2005 Management Studio and I am in the table designer and I'm editing the column definitions It is almost possible to do this entirely without using the mouse. However, if I'm navigating around the cells in this designer using the arrow keys, when I move to a new cell all the text is selected. Say I want to change a decimal(6,2) to decimal(6,3), so I move over there with arrow keys and the whole decimal(6,2) phrase is selected. I have been completely unsuccessful in finding a way to move the cursor to the beginning or end of the line. Instead any combination of ctrl, shift, alt and arrow keys blithely select the adjacent cell in that arrow's direction. So inevitably, I have to take my hands from the keyboard and use the mouse to click within the cell I want to edit and then I can edit the value without having to retype the entire thing.

GRRR!

Can anyone help me out with this one?

I will be eternally grateful (or at least as long as I use Sql server management studio)!

Thanks,

like image 596
argyle Avatar asked Jul 18 '11 05:07

argyle


2 Answers

Uh... F2, right? That's always worked for me, in just about any program where you edit a grid

like image 170
user2766039 Avatar answered Sep 28 '22 03:09

user2766039


While playing around with @Damien's answer I found out an even better answer that I basically accept as the answer.

If you move to a cell and all the text is selected you can hit the escape key. All the text will still be selected but at this point you can use the navigation keys like arrows and Home and End and they will work as expected.

like image 32
argyle Avatar answered Sep 28 '22 03:09

argyle