获取原始类型为表和视图的同义词

在做数据字典设计时碰到的问题，以便以后查找，先记录下来。

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