Saturday 6 May 2017

How to get all procedures name with schema in SQL Server? [Resolved]

There are various way to achieve this.

No 1
select * from sys.procedures



No 2
Select OBJECT_SCHEMA_NAME([object_id])+'.'+ name FROM sys.procedures


No 3
SELECT
SchemaName = s.name,
ProcedureName = pr.name
FROM
sys.procedures pr
INNER JOIN
sys.schemas s ON pr.schema_id = s.schema_id