> 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-functions.md).

# Stored Functions

{% columns %}
{% column %}
{% content-ref url="/pages/F8MWcPnvNbq1zhr5cCRg" %}
[Stored Function Overview](/docs/server/server-usage/stored-routines/stored-functions/stored-function-overview.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
A Stored Function is a set of SQL statements that can be called by name, accepts parameters, and returns a single value, enhancing SQL with custom logic.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/ZdTl3TlsM9S3BOcwlBlk" %}
[Stored Aggregate Functions](/docs/server/server-usage/stored-routines/stored-functions/stored-aggregate-functions.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Stored Aggregate Functions allow users to create custom aggregate functions that process a sequence of rows and return a single summary result.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/b73phnOEgu1fqKRt8QYa" %}
[Stored Routine Privileges](/docs/server/server-usage/stored-routines/stored-functions/stored-routine-privileges.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
This page explains the privileges required to create, alter, execute, and drop stored routines, including the automatic grants for creators.
{% 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 %}
The DROP FUNCTION statement removes a stored function from the database, deleting its definition and associated privileges.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/OAIFOSooweZV29V6YqoM" %}
[Stored Function Limitations](/docs/server/server-usage/stored-routines/stored-functions/stored-function-limitations.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
This page details the restrictions on stored functions, such as the inability to return result sets or use transaction control statements.
{% endcolumn %}
{% endcolumns %}