ORACLE 数据库同义词查询及删除方法

  查询同义词，可通过查询user_synonyms及all_synonyms两个表来完成。
select synonym_name,table_owner,table_name from user_synonyms;
select owner,synonym_name,table_owner,table_name from all_synonyms where owner='SCOTT';


删除时，使用drop synonym name或drop public synonym name
drop synonym tab;