How to search in the code of Synonyms?

Toad for SQL Server
1

Do you know a way to search in the code of Synonyms in SQL Server?

The object "synonym" does not seem to be available in the "Find" section for Object Search.

Thanks
Vincent

2

Hi @vincent.rives

I know workaround for it

  1. Right click on DB in Object Explorer -> DDL Script
  2. Select Synonym
  3. Select all objects from list and generate DDL script
  4. Open generated script in editor and search in text

image
image1148×572 112 KB

Hope this helps

1 Like
3

Thank you Vasiliy. Very useful.

Ideally this would be better if we could search a key words in all the objects including synonyms.

I wonder how I could check if some users already asked for that same feature.
Would a post in the idea section of that forum be enough?