2022. 12. 15. 09:49
SQL SERVER
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
'SQL SERVER' 카테고리의 다른 글
| 실행중인 SQL확인 (0) | 2023.09.11 |
|---|---|
| Agent Job 실패확인 (0) | 2023.09.11 |
| 전체Table Size 확인 (0) | 2022.11.08 |
| SQL 실행횟수 모니터링 (0) | 2022.03.15 |
| DB 이관시 설정상태 체크, 변경 (0) | 2022.02.07 |