SQL Prompt Tips #1 - Selecting in the Object Explorer

  • Comments posted to this topic are about the item SQL Prompt Tips #1 - Selecting in the Object Explorer

  • Good Morning.

    How may I configure this shortcut?

    Thanks.

  • There is no configuration. This is already set if you use SQL Prompt. If you don't have SQL Prompt, then I don't know how this would work.

  • Hi Steve

    This sounds like a really useful tip, but what should I look for if it doesn't work?

    Ctrl/F12 does absolutely nothing, yes I do have SQL Prompt installed and it works fine when prompting.

    (SSMS 11.0.3000.0)

    Thanks

    Adrian

  • That's a tough question. I'd contact support. It's possible you have a key overload of some sort, based on your environment. Do you have Prompt 6? I think 6.3 is the latest incremental build.

    You can post a note here: http://www.red-gate.com/messageboard/viewforum.php?f=169 or click the contact support item.

  • Only works for me if I highlight the object name and that name is not in brackets.

  • it's working fine now, dunno what happened the previous time 🙂

    Thanks for the help

  • I am a huge fan of Sql Prompt. Prior it seemed i would manage to memorize most of the database for quick querying.

    Do you know of a method to copy to pasteboard the quick text from sql prompt?

    EX: typing an exec stored procedure or select from a table a pause allows sql prompt to show the DDL.

    A short cut key to copy that code w/o taking hands off of the keyboard and using the mouse to click to copy button would be fantastic.

    thanks

    daryl

  • This function will silently fail (no error msg) if the object you are searching for is new and does not yet appear in the object tree. Refreshing the tree may be necessary after creating an object. That would explain why it appeared to fail, but then later worked.

  • CTRL+Shift+D will refresh.

  • Daryl AZ (10/14/2015)


    I am a huge fan of Sql Prompt. Prior it seemed i would manage to memorize most of the database for quick querying.

    Do you know of a method to copy to pasteboard the quick text from sql prompt?

    EX: typing an exec stored procedure or select from a table a pause allows sql prompt to show the DDL.

    A short cut key to copy that code w/o taking hands off of the keyboard and using the mouse to click to copy button would be fantastic.

    thanks

    daryl

    Which text? Can you show an example? I'm not sure what you mean.

    BTW, you can submit suggestions on UserVoice, which the Prompt team is using for driving work.

    https://redgate.uservoice.com/forums/94413-sql-prompt

  • Oooooo Good tip.

  • Ex.

    Typing 'Select * from MyTable..' in SSMS SqlPrompt then brings up a list of tables fitting that spelling.

    Using arrow key down to go to specific table.

    At that point SqlPrompt then to the right of the table suggestions pops up a window with the DDL language for the suggested table. (or stored procedure)

    Using the mouse to click 'copy' I then have the code for the table/sproc for debugging, investigating.

    thanks

    daryl

Viewing 14 posts - 1 through 13 (of 13 total)

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