Ability to create a public synonym on top of a sequence - by JoeA27

Status : 

  Won't Fix<br /><br />
		Due to several factors the product team decided to focus its efforts on other items.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.


2
0
Sign in
to vote
ID 773602 Comments
Status Closed Workarounds
Type Suggestion Repros 0
Opened 12/5/2012 2:59:36 PM
Access Restriction Public

Description

In SQL Server 2012, you are not able to create a synonym on top of a sequence.  When sequences are associated with a specific schema, this would be helpful, as most other objects you are able to use this functionality.

Thanks
Sign in to post a comment.
Posted by TMMike on 10/16/2013 at 9:38 AM
This would be useful if you want to change the name of a sequence without requiring an application change. Our app supports Oracle and Sql Server, and I'm using an Oracle synonym to minimize down time as we change a sequence name in Oracle (we use identities in the Sql Server variant of our app, so for now it's not an issue there). I know you guys are busy, I'm still going to put in a vote for this one.
Posted by Microsoft on 2/19/2013 at 4:06 PM
Hi, thank you for your feedback. Since other object types can have 3 or 4 part names, we prioritized supporting synonyms. Since sequences are usually 1-2 part names, our recommendation is to try to align this with the naming scheme being used for the rest of the synonyms. Given our current set of prioritizations, we unfortunately won't be able prioritize adding this so resolving this connect item.