How to backup or script all the Synonyms of the database in SSMS?

Question

score 5 · Accepted Answer · answered Jul 03 '19 at 14:05

Right click your database in the object Explorer, and select "Tasks" -> "Generate Scripts...". On the Choose Objects window, select the "Select specific database objects" and tick "Synonyms" (like below):

Choose whether you want to save file to disc, clipboard or a new query window. Click Next and the next.

Done.

How to backup or script all the Synonyms of the database in SSMS?

1 Answers1