DROP SYNONYM command

This command removes a PUBLIC synonym from the database.

Syntax

DROP SYNONYM synonym_name
Keyword Description
synonym_name Name of the synonym to drop

Use

This statement is used to remove a synonym referencing a table or view from the database. The removal of a synonym has no effect on the base object to which it refers.

The CREATE SYNONYM statement is used to create a synonym name.

Example

DROP SYNONYM REPS