Toad World® Forums

How to search in the code of Synonyms?

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.


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

Hope this helps

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?