2012年2月25日星期六

Any keyboard shortcut for "open table" in Mgt Studio?

Folks, does anyone know if there is a keyboard shortcut to open a database table in Management Studio? I refer to the equivalent to right-clicking on a table to choose "open table", in order to view/edit the data.

I find no reference to an equivalent in the menu, nor even any reference to "open table" in the online help. I've dug around the web, to no avail. Surely other keyboard fans must groan at the need to touch the mouse for this frequent operation. Thanks in advance.

Windows functionality:

SHIFT+F10 Opens a shortcut menu for the selected item (this is the same as right-clicking an object
ALT+underlined letter in menu: Opens the menu

|||Might refer to the keyboard shortcuts on using SSMS ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/toolref9/html/fb4edf3c-71b6-4645-b1d1-ddfdd69f0d7b.htm link. Why do you need to open the table in SSMS which is slow if the table has too many rows or volume based. In thsi case using Query Analyzer is best one to go to view the data.|||Thanks very much. I'm a big keyboard fan, but that's one I'd just missed (or not had reason to notice it before). That does solve the problem for me.|||

Thanks, but that's about creating new shortcuts. I was looking for any existing ones. The previous answer about using shift-f10 will suffice.

As for why one would use the "open table" option, do you realize that it permits editing the data? That's certainly much easier in that interface than using SQL statements in query analyzer. Sure, you're right that if you had a large table it may not make sense. I don't, so it works fine for me.

没有评论:

发表评论