How to find stored procedures and functions from all schemas in Snowflake?

Question

How to find stored procedures and functions from all schemas in Snowflake?

Table Information_schema.procedure gives details from individual database only. I need to find it out from all schema in system. How can I do it in Snowflake?

Thank you, Shrini

Answer 1

SHOW PROCEDURES IN ACCOUNT;

SHOW USER FUNCTIONS IN ACCOUNT;

Both of these will list all objects that your current role has access to. If run as ACCOUNTADMIN, they will return everything.