Search code examples
sql-serversql-server-2005synonym

Edit synonyms in MS SQL Server 2005

Out of curiousity, is there any way to edit an existing synonym? That is, change which table the synonym is pointing to...

Thus far I seem to have had to delete and re-create them, because they're locked from being edited. It's not a big deal, but at the same time it's a little irritating.

GUI or scripting, but preferably GUI.

Solution

  • There is no 

    ALTER SYNONYM

    You have to drop and recreate the synonym. See this article.