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 arro开发者_C百科w 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,
Uh... F2, right? That's always worked for me, in just about any program where you edit a grid
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.
Okay, this is ugly, but you can do it with 3 keyboard actions: SPACE, CTRL-Z, RIGHT ARROW leaves the cursor at the end of the text, left arrow is then moving the cursor within the text.
But as I said in my comment, I'd just use a query window and write the SQL directly rather than using the table designer.
精彩评论