| Informix Guide to SQL: Syntax SQL Statements |
|
|
DROP SYNONYM Use the DROP SYNONYM statement to remove a previously defined synonym.
|
| Element | Purpose | Restrictions | Syntax |
|---|---|---|---|
| synonym | Name of the synonym to drop | The synonym and the table to which the synonym points must exist. | Database Object Name, p. 4-50 |
You must be the owner of the synonym or have the DBA privilege to use the DROP SYNONYM statement.
The following statement drops the synonym nj_cust, which cathyg owns:
If a table is dropped, any synonyms that are in the same database as the table and that refer to the table are also dropped.
If a synonym refers to an external table, and the table is dropped, the synonym remains in place until you explicitly drop it using DROP SYNONYM. You can create another table or synonym in place of the dropped table and give the new database object the name of the dropped table. The old synonym then refers to the new database object. For a complete discussion of synonym chaining, see the CREATE SYNONYM statement.
Related statement: CREATE SYNONYM
For a discussion of synonyms, see the Informix Guide to SQL: Tutorial.