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

    The Scary DBA
    Author of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd Edition
    Product Evangelist for Red Gate Software

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

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