title: Edit synonyms in MS SQL Server 2005
body: <p>Out of curiousity, is there any way to <em>edit</em> an existing synonym?  That is, change which table the synonym is pointing to...  </p>
  
  <p>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.</p>
  
  <p>GUI or scripting, but preferably GUI.</p>