> For the complete documentation index, see [llms.txt](https://mariadb.com/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://mariadb.com/docs/server/reference/sql-statements/stored-routine-statements.md).

# Stored Routine Statements

{% columns %}
{% column %}
{% content-ref url="/pages/B0OGd2N3wuwEt0agmpsd" %}
[CALL](/docs/server/reference/sql-statements/stored-routine-statements/call.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Invoke a stored procedure. This statement executes a previously created stored procedure, optionally passing parameters and returning results.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/y83lVJTn0gf3ZfJIfdiU" %}
[DO](/docs/server/reference/sql-statements/stored-routine-statements/do.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Execute expressions without returning a result set. This statement runs functions or expressions, often used for side effects like releasing locks.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/tcfPKdojxsmOYTkOnd6i" %}
[CREATE PROCEDURE](/docs/server/server-usage/stored-routines/stored-procedures/create-procedure.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Define a new stored procedure, specifying its name, parameters (`IN`, `OUT`, `INOUT`), and the SQL statements it executes.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/47mzLbKZ5imzX9IGowXm" %}
[ALTER PROCEDURE](/docs/server/server-usage/stored-routines/stored-procedures/alter-procedure.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Modify the characteristics of an existing stored procedure, such as its security context or comment, without changing its logic.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/qNWucfv7uoVUBob9Y6O1" %}
[DROP PROCEDURE](/docs/server/server-usage/stored-routines/stored-procedures/drop-procedure.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Remove a stored procedure and its associated privileges from the database.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/NFkMMTQ3dvd48AfE7Gu3" %}
[DROP FUNCTION](/docs/server/server-usage/stored-routines/stored-functions/drop-function.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Remove a stored function from the database, deleting its definition and associated privileges.
{% endcolumn %}
{% endcolumns %}