Warm tip: This article is reproduced from stackoverflow.com, please click
sql sql-server ssms ssms-2017

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

发布于 2020-03-27 10:20:34

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

Questioner
Neeraj Kumar
Viewed
118
Larnu 2019-07-03 22: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):

enter image description here

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

Done.