Neoview SQL Reference Manual (R2.4)

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 289).
DROP SYNONYM alternate-name
Syntax Description of DROP SYNONYM
alternate-name
specifies the name of the synonym. See “Database Object Names” (page 228).
Considerations for DROP SYNONYM
• When the object being referenced by the synonym is dropped, then the synonym is also
dropped.
• Only the owner of the synonym or schema can create, alter, or drop the alternate names.
• GRANT and REVOKE commands are allowed on synonyms. The command will be applied
to the actual reference object.
• View, constraints, and trigger text cannot use synonym names in their DML text.
• Synonyms cannot be renamed. The RENAME operation is allowed on actual table names
only.
Example of DROP SYNONYM
This example drops a synonym:
DROP SYNONYM aname
DROP SYNONYM Statement 113