Edit synonyms in MS SQL Server 2005

Question

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.

Accepted Answer

There is no

```
ALTER SYNONYM
```

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

Edit synonyms in MS SQL Server 2005

Solution

Problem