# Stored Routine Statements

{% columns %}
{% column %}
{% content-ref url="stored-routine-statements/call" %}
[call](https://mariadb.com/docs/server/reference/sql-statements/stored-routine-statements/call)
{% 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="stored-routine-statements/do" %}
[do](https://mariadb.com/docs/server/reference/sql-statements/stored-routine-statements/do)
{% 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="../../server-usage/stored-routines/stored-procedures/create-procedure" %}
[create-procedure](https://mariadb.com/docs/server/server-usage/stored-routines/stored-procedures/create-procedure)
{% 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="../../server-usage/stored-routines/stored-procedures/alter-procedure" %}
[alter-procedure](https://mariadb.com/docs/server/server-usage/stored-routines/stored-procedures/alter-procedure)
{% 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="../../server-usage/stored-routines/stored-procedures/drop-procedure" %}
[drop-procedure](https://mariadb.com/docs/server/server-usage/stored-routines/stored-procedures/drop-procedure)
{% endcontent-ref %}
{% endcolumn %}

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

{% columns %}
{% column %}
{% content-ref url="../../server-usage/stored-routines/stored-functions/drop-function" %}
[drop-function](https://mariadb.com/docs/server/server-usage/stored-routines/stored-functions/drop-function)
{% endcontent-ref %}
{% endcolumn %}

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