how to get all the Dynamic Management Views and Functions (from a table or a view) RRS feed

  • Question

  • Is there any data dictionary (table or view) which will list ALL Dynamic Management Views and Functions?
    Friday, October 28, 2011 1:25 AM


  • Daniel, any reason why you want to do that? Books online has the entire list. In any case the following should give it to you.


    * FROM sys.all_views where name like 'dm_%'

    Hope this helps


    Thank you and regards Shishir Khandekar
    • Marked as answer by Daniel Wu Friday, October 28, 2011 2:16 AM
    Friday, October 28, 2011 1:42 AM