> 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/data-definition/alter.md).

# ALTER

{% columns %}
{% column %}
{% content-ref url="/pages/B2elO6LbtPER1kKs2SwF" %}
[ALTER DATABASE](/docs/server/reference/sql-statements/data-definition/alter/alter-database.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Modify database characteristics. Learn how to change global properties like the default character set and collation for a specific database.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/VGJY8BrgY0LmRUvrf0iD" %}
[ALTER FUNCTION](/docs/server/reference/sql-statements/data-definition/alter/alter-function.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Change stored function characteristics. This statement allows modifying the security context or comments of a stored function without dropping it.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/94wTkgZidqcg9kCzhIrQ" %}
[ALTER LOGFILE GROUP](/docs/server/reference/sql-statements/data-definition/alter/alter-logfile-group.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Understand the support status of this statement. Originally designed for NDB Cluster, it is not currently supported in MariaDB Server.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/uM8aMd0lyZQPgVptCdJP" %}
[ALTER SERVER](/docs/server/reference/sql-statements/data-definition/alter/alter-server.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Modify server definitions. Update connection information for external servers defined with CREATE SERVER, primarily used by the Federated engine.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/zQ663vOS8tEnQkPqI2MG" %}
[ALTER TABLE](/docs/server/reference/sql-statements/data-definition/alter/alter-table.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Complete ALTER TABLE guide for MariaDB. Complete syntax for modifying columns, indexes, constraints, and table properties with comprehensive examples and.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/t38QKDcGv4YoDJCX1LjH" %}
[ALTER TABLESPACE](/docs/server/reference/sql-statements/data-definition/alter/alter-tablespace.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Understand the status of tablespace management. This statement, originally for NDB, is not supported in MariaDB for InnoDB tablespaces.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/TYmDM1OmOrS1lHMHnx2Y" %}
[ALTER VIEW](/docs/server/server-usage/views/alter-view.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Documentation for the ALTER VIEW statement, which is used to modify an existing view's definition without dropping and recreating it.
{% endcolumn %}
{% endcolumns %}