获取原始类型为表和视图的同义词
在做数据字典设计时碰到的问题，以便以后查找，先记录下来。http://www.agoit.com/images/smiles/icon_arrow.gifSqlServer:select s.namefrom 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.namefrom sys.synonyms as s left join sys.views as v on object_name(object_id(s.base_object_name)) = v.name wherev.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
页:
[1]