How can we improve SQL Prompt?

Synonym support

I found several feature requests concerning synonym support on the Red Gate forums: It was always put on the feature request list, but SQL Prompt still lacks support for synonyms.
Explanation: Synonym resolution support is crucial for us, since our database design and development strategy completely relies on them. We use synonyms for everything that is out of current database context. So we develop as if every used object was within current database. It's annoying to type an object name that is in fact a synonym - and SQL Prompt does not display auto-completion for the object itself nor for its columns etc. This renders SQL Prompt's auto completion and suggestions useless in many cases for us.

102 votes
Sign in
Password icon
Signed in as (Sign out)

We’ll send you updates on this idea

Anonymous shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →


Sign in
Password icon
Signed in as (Sign out)
  • Stephen commented  ·   ·  Flag as inappropriate

    At the moment it's in the "Experimental Features" section. As at October 19, 2012, no COLUMN prompting is available.

  • AdminJustin Caldicott (Admin, Redgate) commented  ·   ·  Flag as inappropriate

    A little update. The next release ( that I referred to is now already complete, and synonym support was started about a week ago. We are moving to a more frequent release cycle for development changes to our early access list. We're keen to get your feedback on our implementation of this feature, so if you would like to receive more regular updates then please sign up to our early access list here: Thanks!

  • Petr commented  ·   ·  Flag as inappropriate

    If synonym support is not planned within one year, I'm not going to buy upgrade for next year...

  • Vinod Mishra commented  ·   ·  Flag as inappropriate

    I have waited more than a year for this feature and it seems SQL Assistant supports synonyms just fine. I do prefer SQL Prompt but I think I will move to SQL Assistant as it has all the features I want.

  • Klaus Ondrich commented  ·   ·  Flag as inappropriate

    @Justin: Thanks for the update. However, it is quite unsatisfactory. Synonym support has been in the queue (at least) since SQL Prompt 4. Now we currently stand at version 5.2 and hear that it will not be available in the next release. That's very disappointing and reduces SQL Prompt's value extremely, since we completely rely our database development on synonyms (in fact SQL Prompt is just useful for in-database objects, since all "remote" objects are made local through synonyms).

  • Justin Caldicott commented  ·   ·  Flag as inappropriate

    Thanks for the input and patience! This is something that we do intend to address. It’s quite an involved change and won’t make the next release, but we’ll update this page with progress.

  • Stephen Anslow commented  ·   ·  Flag as inappropriate

    This has been "Under Review" for OVER SIX MONTHS.

    Not wishing to be rude but this is far too long a "review" window.

    With 176 votes at the time of posting, you (RG) appear to have a decent amount of clamor in the community.


  • Nathan Bedford commented  ·   ·  Flag as inappropriate

    RedGate, this is a pretty critical issue for us too! Can you give us an ETA? Will this make it into the next release?

  • Stephen Solt commented  ·   ·  Flag as inappropriate

    just wanted to add my comment. Synonyms are really useful for moving from test to production environments and keeping SQL code as general as possible.

  • Michael Sumerano commented  ·   ·  Flag as inappropriate

    Synonym support has been added to SSMS for SQL Server Denali. You can downloat the current CTP to see it in action.

  • Breadon commented  ·   ·  Flag as inappropriate

    I find them much more flexible to use than LinkedServers. Uses include preparing for server consolidation ie when a database changes server. Unlike when using views, the column list will reflect an underlying table when the underlying schema changes.

  • Lars Wisler commented  ·   ·  Flag as inappropriate

    Synonyms are not only smart but also getting more and more "common", so full synonym support is a must whereever used.

    So please add this to make a great product even greater! :-)

  • Stephen commented  ·   ·  Flag as inappropriate

    Just used my first synonym and oh, the disappointment of having NO suggestions... Deep woe... Hope the "Under Review" elicits a "Started" status v. soon...

  • sm commented  ·   ·  Flag as inappropriate

    We have started using synonyms, and I would like to vote for the synonym support by SQL prompt.

← Previous 1

Feedback and Knowledge Base