DROP SYNONYM in SQL Server

An alternative name or alias for a table, view, sequence, or other schema item is known as a synonym in databases. In dynamic SQL, it can be created, removed, and referenced. The Synonyms can be deleted using the DROP statement, much like other database objects.

Synonym references are not schema-bound, therefore you are free to remove any synonym at any moment. Only at run time will references to dropped synonyms be discovered.

Syntax:
DROP SYNONYM [ IF EXISTS ] [ schema. ] synonym_name

Example:
DROP SYNONYM Trxns;