Search This Blog

Query to return list of Dynamic Management Views

SELECT * FROM sys.all_objects
WHERE [name] LIKE '%dm_%'
AND [type] IN ('V', 'TF', 'IF')
AND [schema_id] = 4
ORDER BY [name]

No comments: