|
|
|
DROP SYNONYM
Description
Drops the specified synonym.
Syntax
DROP [PUBLIC] SYNONYM [owner_name.]synonym ;
Arguments
PUBLIC
Specifies that the synonym was created with the PUBLIC argument.
FairCom DB SQL generates the Base table not found error if DROP SYNONYM specifies PUBLIC and the synonym was not a public synonym. Conversely, the same error message occurs if DROP SYNONYM does not specify public and the synonym was created with the PUBLIC argument.
To drop a public synonym, you must have the DBA privilege.
owner_name
If owner_name is specified and is different from the name of the user executing the statement, then the user must have DBA privileges.
synonym
Name for the synonym.
Example
DROP SYNONYM customer ;
DROP PUBLIC SYNONYM public_suppliers ;
Authorization
Users executing DROP SYNONYM must have either the DBA privilege or be the owner of the synonym. Users executing DROP PUBLIC SYNONYM must have the DBA privilege.
SQL Compliance |
Extension |
Environment |
Embedded SQL, interactive SQL, ODBC applications |
Related Statements |
CREATE SYNONYM |
