Use this statement to remove a procedure from the database.
DROP PROCEDURE [ IF EXISTS ] [ owner.]procedure-name
Use the IF EXISTS clause if you do not want an error returned when the DROP PROCEDURE statement attempts to remove a procedure that does not exist.
You cannot execute a DROP PROCEDURE statement when the statement affects an object that is currently being used by another connection.
Any user who owns the object, or has DBA authority, can execute the DROP PROCEDURE statement.
Automatic commit. Clears the Results tab in the Results pane in Interactive SQL.
SQL/2003 Core feature.
Drop MyProcedure from the database. If the procedure does not exist, an error is returned.
DROP PROCEDURE MyProcedure;
|Discuss this page in DocCommentXchange.
Send feedback about this page using email.
|Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1|