How to display all the Procedures, Function, Triggers and other objects those are present in the SQL Server DB and its details.

How to display all the Procedures, Function, Triggers and other objects those are present in the SQL Server DB and its details.

SELECT SPECIFIC_NAME,ROUTINE_DEFINITION from information_schema.routines

Use below queries as well for more information

SELECT SPECIFIC_NAME,ROUTINE_DEFINITION FROM INFORMATION_SCHEMA.ROUTINES

SELECT * FROM INFORMATION_SCHEMA.ROUTINES ORDER BY ROUTINE_TYPE

SELECT DISTINCT ROUTINE_TYPE FROM  INFORMATION_SCHEMA.ROUTINES