Skip to content
← SQL Prompt

How can we improve SQL Prompt?

SQL Prompt: Intellisense

Categories

JUMP TO ANOTHER FORUM

(thinking…)

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

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

Anonymous shared this idea  ·   ·  Report…  ·  Admin →

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • Nicholas Orlando commented  ·   ·  Report

    I love the support for synonym names. Would it be possible to also get columns?

  • Stephen commented  ·   ·  Report

    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  ·   ·  Report

    A little update. The next release (5.2.2.1) 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: https://www.surveymk.com/s/DZLN2JW Thanks!

  • Petr commented  ·   ·  Report

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

  • Vinod Mishra commented  ·   ·  Report

    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  ·   ·  Report

    @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  ·   ·  Report

    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  ·   ·  Report

    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.

    UPDATE PLEASE!

  • Nathan Bedford commented  ·   ·  Report

    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  ·   ·  Report

    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.

  • Alessandro Alpi commented  ·   ·  Report

    SQL Search, 1.0.0.342 has an object type called "Others".
    Using that you can search on synonyms too..

  • Breadon commented  ·   ·  Report

    Have just noticed that SQL Search also appears to ignore synonyms.

  • Michael Sumerano commented  ·   ·  Report

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

  • Breadon commented  ·   ·  Report

    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  ·   ·  Report

    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  ·   ·  Report

    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  ·   ·  Report

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

← Previous 1