CODE EXAMPLE FOR SQL

sql list all procedures

SELECT
	"routine_type",
	"specific_catalog",
	"routine_name",
	"routine_definition"
  FROM db_name.INFORMATION_SCHEMA.ROUTINES
 WHERE ROUTINE_TYPE = 'PROCEDURE'