Answers for "sql server query to get all stored procedure"

sql script get all stored procedures from database

SELECT 
  SCHEMA_NAME(schema_id) AS [Schema],
  name
FROM sys.objects
WHERE type = 'P';

Posted by: Guest on December-07-2020

Code answers related to "sql server query to get all stored procedure"