ALTER

Access the reference for ALTER statements. This section lists commands to modify existing database objects, including tables, databases, users, and servers.

ALTER DATABASE

Modify database characteristics. Learn how to change global properties like the default character set and collation for a specific database.

ALTER FUNCTION

Change stored function characteristics. This statement allows modifying the security context or comments of a stored function without dropping it.

ALTER LOGFILE GROUP

Understand the support status of this statement. Originally designed for NDB Cluster, it is not supported in MariaDB Server.

ALTER SERVER

Modify server definitions. Update connection information for external servers defined with CREATE SERVER, primarily used by the Federated engine.

ALTER TABLE

Complete ALTER TABLE guide for MariaDB. Complete syntax for modifying columns, indexes, constraints, and table properties with comprehensive examples and.

ALTER TABLESPACE

Understand the status of tablespace management. This statement, originally for NDB, is not supported in MariaDB for InnoDB tablespaces.

ALTER VIEW

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

_{This page is licensed: CC BY-SA / Gnu FDL}