Skip to content
← Customer Feedback for Redgate

Settings and activity

2 results found

  1. Drop statement in script

    4 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    1 comment  ·  SQL Source Control » Better Support for Shared Db Dev Model  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    Ed White supported this idea  · 
    An error occurred while saving the comment
    Ed White commented  · 

    I use that script a lot.

    An annoyance in SQL Prompt is that when I type OBJECT_ID and click on the pulldown prompt suggestion for OBJECT_ID, SQL Prompt inserts brackets [ ] around it, resulting in [OBJECT_ID] (I have to option turned on to automatically put brackets around column names). The resulting script
    IF ([OBJECT_ID]('MyTable') IS NOT NULL) DROP TABLE MyTable`
    gives an error--you can't have brackets around OBJECT_ID. So every time I type this, I have to either manually type the entire word OBJECT_ID, or manually remove the brackets.

  2. Automatic Suggestion Refresh

    17 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    3 comments  ·  SQL Prompt » Intellisense  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    Ed White supported this idea  · 
    An error occurred while saving the comment
    Ed White commented  · 

    In addition, in SSMS, whenever 'Refresh Suggestions' is selected, also perfom Edit->Intellisense->Refresh Local Cache automatically.