DROP SYNONYM (Transact-SQL)
Removes a synonym from a specified schema.
Applies to: SQL Server (SQL Server 2008 through current version), Azure SQL Database.
The following example first creates a synonym, MyProduct, and then drops the synonym.
USE tempdb; GO -- Create a synonym for the Product table in AdventureWorks2012. CREATE SYNONYM MyProduct FOR AdventureWorks2012.Production.Product; GO -- Drop synonym MyProduct. USE tempdb; GO DROP SYNONYM MyProduct; GO