> 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/server-usage/stored-routines/stored-procedures.md).

# Stored Procedures

{% columns %}
{% column %}
{% content-ref url="/pages/TzRu73xxKs98w79FWdWh" %}
[Stored Procedure Overview](/docs/server/server-usage/stored-routines/stored-procedures/stored-procedure-overview.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Stored procedures are precompiled collections of SQL statements stored on the server, allowing for encapsulated logic, parameterized execution, and improved application performance.
{% 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 %}
Complete CREATE PROCEDURE guide for MariaDB. Complete reference documentation for implementation, configuration, and usage with comprehensive examples and.
{% 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 %}
The ALTER PROCEDURE statement modifies 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 %}
The DROP PROCEDURE statement permanently removes a stored procedure and its associated privileges from the database.
{% endcolumn %}
{% endcolumns %}