DROP SYNONYM

Removes a synonym from the database.

SYNTAX

DESCRIPTION

The DROP SYNONYM command removes an existing synonym for a table or view from the database. To execute the DROP SYNONYM command, you must be the synonym owner or have DBA or SYSADM security privileges.

DBMaker normally identifies tables and views with fully qualified names that are a composite of the owner name and object name. To help simplify statements that use fully qualified table and view names, DBMaker provides synonyms.

A synonym is an alternative name (alias) that can be used for a table or view. Since a synonym is simply an alias, it requires no storage space other than its definition in the system catalog. Using synonyms, users can access a table or view through the corresponding synonym without having to use the fully qualified name.

You can create more than one synonym for a table or view, but all synonym names must be unique among all other synonym names in the database. This allows users to refer to synonym names without prefixing an owner name. If you own a table with the same name as a synonym, DBMaker will always use your table and ignore the synonym with the same name. To use the table referenced by the synonym, you must provide the fully qualified name for that table. All synonyms on a table or view are dropped automatically if you drop the referenced table or view.
You can drop a synonym from any table in the database except the system tables. DBMaker internally manages all synonyms on the system tables, and will not allow you to drop them.

EXAMPLE

The following example drops the synonym named Staff (created on the Employees table).

DROP SYNONYM Staff

RELATED COMMANDS

• CREATE SYNONYM
• DROP TABLE
• DROP VIEW

< DROP REPLICATION | Contents | DROP TABLE >