Removes the specified stored procedure from the current/specified schema.
CREATE PROCEDURE , ALTER PROCEDURE , SHOW PROCEDURES , DESCRIBE PROCEDURE, SHOW USER PROCEDURES
DROP PROCEDURE [ IF EXISTS ] <procedure_name> ( [ <arg_data_type> , ... ] )
Copy
Usage notes¶All Languages
For each argument defined for the procedure, the data type for the argument must be specified. This is required because overloading of procedure names is supported and the data type(s) for the argument(s) are required to identify the procedure.
When the IF EXISTS clause is specified and the target object doesn’t exist, the command completes successfully without returning an error.
Java, Python, and Scala
For procedures that store code in a file (such as a .jar file or .py file) in a stage, the DROP PROCEDURE command does not remove the file. Different procedures can use different functions/methods in the same file, so the file should not be removed while any procedure refers to it. Snowflake does not store a count of the number of references to each staged file and does not remove that staged file when there are no remaining references.
DROP PROCEDURE add_accounting_user(varchar); -------------------------------------------+ status | -------------------------------------------+ ADD_ACCOUNTING_USER successfully dropped. | -------------------------------------------+Copy
RetroSearch is an open source project built by @garambo | Open a GitHub Issue
Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo
HTML:
3.2
| Encoding:
UTF-8
| Version:
0.7.4