DROP SYNONYM

The DROP SYNONYM statement removes a synonym from the database.

Required privilege

No privilege is required for the synonym owner.

DROP ANY SYNONYM is required to drop another user's synonym.

DROP PUBLIC SYNONYM is required to drop a public synonym.

SQL syntax

DROP [PUBLIC] SYNONYM [schema.]synonym

Parameters

The DROP SYNONYM statement has the parameters:

Parameter	Description
`[PUBLIC]`	You must specify PUBLIC to drop a public synonym. You cannot specify `schema` if you have specified PUBLIC.
`[schema.]synonym`	Specify the schema containing the synonym. If you omit schema, then TimesTen assumes the synonym is in your own schema.

Description

DROP SYNONYM is a DDL statement.

Examples

Drop the public synonym pubemp:

DROP PUBLIC SYNONYM pubemp;
Synonym dropped.

Drop the synjobs synonym:

DROP SYNONYM synjobs;
Synonym dropped.

As user terry with DROP ANY SYNONYM privilege, drop the syntab synonym created by ttuser.

DROP SYNONYM ttuser.syntab;
Synonym dropped.