Open topic with navigation
DROP PROCEDURE — remove a stored procedure
DROP PROCEDURE [
sp_name[ IF EXISTS ] DROP PROCEDURE [ IF EXISTS ] [
DROP PROCEDURE removes the definition of an existing stored procedure. If
schema_name is not specified, an attempt will be made to drop a stored procedure with the specified
sp_name from the current schema. To execute this command the user must be the owner of the stored procedure. See
CREATE PROCEDURE to create a stored procedure.
If the stored procedure does not exist and you specify
IF EXISTS, NuoDB does not generate an error. Otherwise, if the stored procedure does not exist, an error is generated.
Optional. The name of the schema that owns the stored procedure to be dropped. If schema is not provided, the stored procedure must be owned by the current schema.
Name of the stored procedure to remove.
Create a stored procedure. Drop the stored procedure
USE USER SET DELIMITER @ CREATE PROCEDURE prc_boolean1() RETURNS tmp_table1 (column1 BOOLEAN) AS INSERT INTO tmp_table1 VALUES (True), (False), (Unknown), (Null); END_PROCEDURE @ SET DELIMITER ; EXECUTE prc_boolean1();COLUMN1 ------- TRUE FALSE <null> <null>
DROP PROCEDURE prc_boolean1; EXECUTE prc_boolean1();can't find procedure "USER.PRC_BOOLEAN1"