Post reply

How to get the storeprocedure names

  • December 9, 2008 at 10:25 pm

    #203898

    Hi,

    i want list of all the storeprocedure names from the database.

    To get the table names i use

    SELECT distinct(TABLE_NAME )

    FROM ClientAdmin.INFORMATION_SCHEMA.COLUMNS

    same way can anyone help to get the Storeprocedure names

    Thanks,

    Regards,

    Viji

  • December 9, 2008 at 10:45 pm

    #910077

    Just use information_schema.routines view:

    select routine_name from information_schema.routines where routine_type = 'procedure'

    Adi

    --------------------------------------------------------------
    To know how to ask questions and increase the chances of getting asnwers:
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

  • December 9, 2008 at 11:24 pm

    #910082

    Hi Adi,

    Thanks its working !!! really it is highly helpful

    i was trying with something storeprocedures and not with routines.

    By the way can you give me either list of informationschema views and its uses or any links which gives this information?

    Thanks,

    Regards,

    Viji

  • December 10, 2008 at 8:42 am

    #910428

    Books online is your friend. The page below has the information_schema views:

    http://msdn.microsoft.com/en-us/library/ms186778(SQL.90).aspx

  • December 10, 2008 at 7:47 pm

    #910783

    Thanks Chris, Even before I went to the same page while searching for this information_schema view. But might be because of my laziness i didn't go through all the links in that page.

    great help you have done. it opened my eyes. sometimes opportunities are lying on our feet, we should be smart to grab it.

    Thanks,

    Regards,

    Viji

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply