DROP SYNONYM — remove a synonym
DROP [ PUBLIC ] SYNONYM [ IF EXISTS ] synonym_name;
DROP SYNONYM removes a synonym.
PUBLICAt present, only syntax compatibility is available, and the feature will be supported in future versions.
IF EXISTSIf the synonym does not exist, do not throw an error, but issue a prompt.
synonym_nameThe name of synonym to be deleted
Drop a synonym:
DROP SYNONYM IF EXISTS profits;