You cannot ALTER SYNONYM in SQL Server 2005: DROP and RECREATE itPosted: February 25, 2010
You can create SYNONYM in SQL Server 2005 with this syntax:
CREATE SYNONYM yourSynonym
If you want to change a synonym, there is no ALTER command to do it. You need to DROP and CREATE it again with new context.
Here is a sample:
DROP SYNONYM [dbo].[mySynonym]
CREATE SYNONYM [dbo].[mySynonym] FOR [myDB].[dbo].[myTable]