How to list all stored procedures in SQL Server?

andy - 11 Jan, 2013 2339 Views 0 Comment

When you do not have access directly to a SQL Server Management Studio and only have the ability to run the query via web page, you probably want to know how you can get a list of stored procedures stored in the current database. You might also interested to view each stored procedure definition. In this tutorial you will learn a quick snippet code on how to view them.

To view all stored procedures, you can run the following sql query

SELECT * FROM sys.procedures;

To view individual stored procedure definition, you can run the following syntax:

sp_helptext 'stored_procedure_name'


There are no comments available.

Write Comment
0 characters entered. Maximum characters allowed are 1000 characters.

Related Articles

How to restore database using SQL query in TSQL?

If you have a database backup bak file extension and want to restore it using SQL query You can use the built in RESTORE DATABASE function Remember in order to be able to restore a database successfully You need to ...

How to get all table sizes in TSQL?

To get the information about how much space or size used by tables You can retrieve the size information by linking multiple tables in sys tables There are two tables that hold this information The first one is the sys ...