Valid in: SQL, ESQL, OpenAPI, ODBC, JDBC, .NET

The DROP SYNONYM statement deletes one or more synonyms from a database. A synonym is an alias (alternate name) for a table, view, or index. Synonyms are created using Create Synonym (see page CREATE SYNONYM).

Dropping a synonym causes the DBMS Server to re-compile any repeat query or database procedure that references the alias. Dropping a synonym has no effect on views or permissions defined using the synonym.

When a table, view, or index is dropped (using the DROP statement), all synonyms that have been defined for it are dropped.