How do you find your procedures and functions in snowflake?

You have written a procedure and a function in snowflake.

How do you find your procedures and functions in snowflake?
A . SHOW PROCEDURES;
B. SHOW FUNCTIONS;
C. SHOW ALL PROCEDURES AND FUNCTIONS
D. SHOW PROCEDURES, FUNCTIONS

View Answer

Answer: B

Explanation:

This will list all objects that your current role has access to. If you run these commands as ACCOUNTADMIN, they it will return all the PROCEDURES and FUNCTIONS in the account https://docs.snowflake.com/en/sql-reference/sql/show-user-functions.html#show-user-functions https://docs.snowflake.com/en/sql-reference/sql/show-procedures.html#show-procedures