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 AdventureWorks. CREATE SYNONYM MyProduct FOR AdventureWorks.Production.Product; GO -- Drop synonym MyProduct. USE tempdb; GO DROP SYNONYM MyProduct; GO