在做数据字典设计时碰到的问题,以便以后查找,先记录下来。 :arrow:
SqlServer:
select s.name from sys.synonyms as s left join
sys.tables as t on object_name(object_id(s.base_object_name)) = t.name where t.name is not null
union select s.name from sys.synonyms as s left join
sys.views as v on object_name(object_id(s.base_object_name)) = v.name where v.name is not null
Oracle:
select s.synonym_name from user_synonyms s Left Join user_tables t On s.table_name = t.table_name Where t.table_name Is Not Null
Union select s.synonym_name from user_synonyms s Left Join user_views v On s.table_name= v.view_name Where v.View_name Is Not Null