Name

DROP SYNONYM

Synopsis

DROP [PUBLIC] SYNONYM
[schema.]synonym_name

Removes a public or private synonym (synonym_name) from the database.

Keyword

PUBLIC

Specifies that the synonym to be dropped is a public synonym.

Notes

The synonym to be dropped must be in your schema, or you must have the DROP ANY SYNONYM privilege to remove a synonym from another schema or the DROP ANY PUBLIC SYNONYM privilege to remove a public synonym.

Example

The following example removes the public synonym employee from the database:

DROP PUBLIC SYNONYM employee
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset