Short cut key

  • Comments posted to this topic are about the item Short cut key

  • Did anyone else notice the date for this QOTD is a month in the future?

    Doc Brown rules!

    :blink:

  • I'm fairly new to SQL Server so I may not be seeing it. ALT+F1 brings up nothing at all in management studio. Also, isn't sp_help used in code?

    :unsure:

  • The link "SQL Server Management Studio Keyboard Shortcuts" is very helpful.

  • Alt+F1 acts a little different to sp_help. sp_help list specifics for an object while Alt+F1 list all objects in a selected database.

  • Karl_Chand (7/14/2008)


    Alt+F1 acts a little different to sp_help. sp_help list specifics for an object while Alt+F1 list all objects in a selected database.

    Did you really try this?

    Just select a table name and press Alt+F1 and see the result...

  • Even though my Studio is set up for the shortcut, it doesn't do anything. Most probably because I've got a soft-KVM and that seems to blat most shortcuts just because it can. 😉

    I'll have to try it at home.

  • I don't have SQL Server 2005 so I can't test, but according to the keyboard shortcut list on BOL (http://msdn.microsoft.com/en-us/library/ms174205.aspx) there is no ALT+F1 at all. Is this a custom keyboard shortcut?


    Urbis, an urban transformation company

  • Hari.Sharma (7/14/2008)

    Did you really try this?

    Just select a table name and press Alt+F1 and see the result...

    Just select a table name and press Alt+F1, is that all I have to do? I click on a table name in the object explorer and pressed Alt+F1 and nothing happened, so I made a new query and put the table name in there (with and without the database name), and I received an error:

    Msg 102, Level 15, State 1, Line 1

    Incorrect syntax near '.'.

    So what do I need to do to see this? Does doing this in Management Studio Express 2005 not work?

    PS. I see I wasn't the only one to confuse this with the "How Do I" under Help on the toolbar :hehe:

    EDIT:

    Why is this QOTD for next month anyway? I know there is a question for this month, and that would have something to do with it.

  • You have to enclose the object name in double-quotes when using two-part names (include schema)..

    like this : "dbo.spt_values" (in master).

  • As simple as it is:

    -- Query

    USE [MyDataBase]

    GO

    TableName -- Bold shows that it is selected

    -- Now Press Alt+F1

    I think it is very easy and self explanatory.

    See the attachment

  • Yeah so if I got it wrong cos I obviously havent answered it yet as that would be next month can i have the point back til 15th August and then lose it? 😀

    This question is very poor in explanation of what it is asking, like when would you push the help button combo i.e. within a query window or within object explorer?

    The QOTD posters should know what pedants we all are - precision is key ambiguity leads to hell 😀

    --Shaun

    Hiding under a desk from SSIS Implemenation Work :crazy:

  • Hari.Sharma (7/15/2008)


    As simple as it is:

    -- Query

    USE [MyDataBase]

    GO

    TableName -- Bold shows that it is selected

    -- Now Press Alt+F1

    I think it is very easy and self explanatory.

    See the attachment

    Tried that and still got the same error. However, if I removed dbo from the table name, it worked.

    Learnt something new, and still earned a point 😎

  • I dont know the reason but it is working on my system without removing dbo 😎

  • Well it sure doesn't work by default. I tried it in 2005 and 2008 and received nothing. I also note, that the answer, ALT-F1, is not listed in the documentation linked to. I'm calling shenanigans on this one.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

Viewing 15 posts - 1 through 15 (of 51 total)

You must be logged in to reply to this topic. Login to reply