How to get the list of procedures?

Database
Enthusiast

How to get the list of procedures?

Hi,

Is there a way in which we can get the list of stored procedures present in database ( the way we can get the list of tables) ?

TIA.
3 REPLIES
Junior Contributor

Re: How to get the list of procedures?

It's the same way you get the list of tables, it's just a different TableKind:

select * from dbc.tables
where databasename = your_db
and TableKind = 'P'

Dieter
Enthusiast

Re: How to get the list of procedures?

Thanks! :)

Re: How to get the list of procedures?

Thanks !