MySQL 5.0 Reference Manual :: 12 SQL Statement Syntax :: 12.1 Data Definition Statements :: 12.1.3 ALTER PROCEDURE Syntax
Section Navigation [Toggle]
- 12.1 Data Definition Statements
- 12.1.1 ALTER DATABASE Syntax
- 12.1.2 ALTER FUNCTION Syntax
- 12.1.3 ALTER PROCEDURE Syntax
- 12.1.4 ALTER TABLE Syntax
- 12.1.5 ALTER VIEW Syntax
- 12.1.6 CREATE DATABASE Syntax
- 12.1.7 CREATE FUNCTION Syntax
- 12.1.8 CREATE INDEX Syntax
- 12.1.9 CREATE PROCEDURE and CREATE FUNCTION Syntax
- 12.1.10 CREATE TABLE Syntax
- 12.1.11 CREATE TRIGGER Syntax
- 12.1.12 CREATE VIEW Syntax
- 12.1.13 DROP DATABASE Syntax
- 12.1.14 DROP FUNCTION Syntax
- 12.1.15 DROP INDEX Syntax
- 12.1.16 DROP PROCEDURE and DROP FUNCTION Syntax
- 12.1.17 DROP TABLE Syntax
- 12.1.18 DROP TRIGGER Syntax
- 12.1.19 DROP VIEW Syntax
- 12.1.20 RENAME TABLE Syntax
ALTER PROCEDUREproc_name[characteristic...]characteristic: { CONTAINS SQL | NO SQL | READS SQL DATA | MODIFIES SQL DATA } | SQL SECURITY { DEFINER | INVOKER } | COMMENT 'string'
This statement can be used to change the characteristics of a
stored procedure. More than one change may be specified in an
ALTER PROCEDURE statement. However,
you cannot change the parameters or body of a stored procedure
using this statement; to make such changes, you must drop and
re-create the procedure using DROP
PROCEDURE and CREATE
PROCEDURE.
As of MySQL 5.0.3, you must have the ALTER
ROUTINE privilege for the procedure. (That privilege is
granted automatically to the procedure creator.)
User Comments
Add your own comment.