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

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

Latest ARA-C01 Dumps Valid Version with 156 Q&As

Latest And Valid Q&A | Instant Download | Once Fail, Full Refund

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments