F4 certainly works. In my humble opinion, it takes too long :).

While I am typing in SQA and SSMS, I use two macors all of the time:

sp_help and sp_helptText.

I used type them out all of the time but that took way too long and too many typos resulted. You see, my fingers are extra-ordinarily fat - sorry for the graphic.

So I pointed keyboard macros at both of these scripts

Alt+F1 = sp_help

CTRL+F1 = sp_helptext

sp_help comes default as macro Alt+F1. Ctrl+F1 wokrs with sprocs, views, udfs - not tables. Since both reside in MASTER, they will work across all of your databases.

Good luck,

-Mike