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

Question

Steilla Mitchel · Answer

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;and

Ashutosh Kumar Verma · Answer

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

interview

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

Ashutosh Kumar Verma

Can you answer this question?

2 Answers

Liked By