---
title: "What is the SQL command to find all stored procedures from database?"  
description: "What is the SQL command to find all stored procedures from database?"  
author: "Ashutosh Kumar Verma"  
published: 2021-11-09  
canonical: https://www.mindstick.com/interview/33808/what-is-the-sql-command-to-find-all-stored-procedures-from-database  
category: "mssql server"  
tags: ["sql server", "sql"]  
reading_time: 1 minute  

---

# What is the SQL command to find all stored procedures from database?

What is the SQL command to find all stored procedures from database?

## Answers

### Answer by Steilla Mitchel

## SQL Command to find all Stored Procedures:

The following SQL command is used to find all the Stored Procedures of current active database in SQL Server

```
select * from sys.objects where type='p';
```

The following SQL command also returns the same values as above command

```
select * from Sys.procedures; 
```

![What is the SQL command to find all stored procedures from database?](https://www.mindstick.com/interviewquestion/65db96bc-47eb-4b98-ad5d-85578f7a9b86/images/6c66caaa-8a9d-4f29-8ea8-79bedf1766a9.png)\

### Answer by Ashutosh Kumar Verma

What is the SQL command to find all stored procedures from database?


---

Original Source: https://www.mindstick.com/interview/33808/what-is-the-sql-command-to-find-all-stored-procedures-from-database

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.