none
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

Answers

  • 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.

    SELECT

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

    Hope this helps

    Shishir


    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