Is the name of the synonym to be dropped. Remarks. References to synonyms are not schema-bound; therefore, you can drop a synonym at any time. References to ... ... <看更多>

You can use a PLSQL anonymous block: begin execute immediate 'drop synonym YOUR_SYNONYM'; exception when others then if sqlcode != ... <看更多>

No, dropping a synonym requires a Sch-M lock, and also IX locks on sysschobjs / sysobjvalues , at least if it is on the same server (I haven't tested what ... ... <看更多>

... <看更多>