synonym의 base object 조회

SELECT OBJECT_SCHEMA_NAME(s.object_id, DB_ID()) Schema_name
, s.name Table_name
, s.base_object_name 
, OBJECTPROPERTYEX(OBJECT_ID(s.[name]), 'BaseType') as BaseType
, ao.type_desc
FROM sys.synonyms s
JOIN (SELECT DISTINCT type, type_desc from sys.all_objects) ao on CONVERT(varchar(2),OBJECTPROPERTYEX(OBJECT_ID(s.[name]), 'BaseType')) = ao.type

 

https://codingsight.com/sql-server-synonyms/