Displays information about the specified synonyms. If you do not specify any aliases in the synonym names that you specify, SQL displays this information about all attached databases. The name of the target object, possibly another synonym, is displayed.