Neoview SQL Reference Manual (R2.5)

DROP SYNONYM Statement
• “Syntax Description of DROP SYNONYM ”
• “Considerations for DROP SYNONYM”
• “Example of DROP SYNONYM”
The DROP SYNONYM statement allows you to drop synonyms for tables, views, or materialized
views that can be used in queries. See “Synonyms” (page 309).
DROP SYNONYM alternate-name
Syntax Description of DROP SYNONYM
alternate-name
specifies the name of the synonym. See “Database Object Names” (page 242).
Considerations for DROP SYNONYM
• When the object being referenced by the synonym is dropped, then the synonym is also
dropped.
• Only the schema owner or synonym owner can drop the synonym.
Example of DROP SYNONYM
This example drops a synonym:
DROP SYNONYM aname
DROP SYNONYM Statement 117