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