Query to return list of Dynamic Management Views

I don't always remember names of the SQL Server Dynamic Managment views.  Books Online is great, but here is a simple query to get a list of DMVs


SELECT * FROM sys.all_objects

   WHERE [name] LIKE '%dm_%'

                AND [type] IN ('V', 'TF', 'IF')

                AND [schema_id] = 4

ORDER BY [name]


Skip to main content