DROP SYNONYM (Transact-SQL)
Removes a synonym from a specified schema.
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