查看DMOs所有物件清單

查看DMOs所有物件清單如下:

SELECT [name] ,

 CASE [type]

 WHEN 'V' THEN 'DMV'

 WHEN 'IF' THEN 'DMF'

 END AS [DMO Type]

FROM [sys].[sysobjects]

WHERE [name] LIKE 'dm_%'

ORDER BY [name] ;