Data Definition (DDL)

Learn data definition language (DDL) statements in MariaDB Server. This section covers SQL commands for creating, altering, and dropping databases, tables, indexes, and other schema objects.

Atomic DDL

Learn about crash-safe DDL operations in MariaDB. This feature ensures data definition statements are either fully committed or completely rolled back, preventing metadata inconsistency.

CONSTRAINT

Complete constraints reference: PRIMARY KEY, FOREIGN KEY, UNIQUE, and CHECK syntax in CREATE/ALTER TABLE, ON DELETE/UPDATE actions, TABLE_CONSTRAINTS table.

RENAME TABLE

Change the name of one or more tables atomically. This command moves tables within or between databases while preserving their data and structure.

Renaming Databases

Learn the supported methods for renaming a database. Since RENAME DATABASE is not available, this guide outlines safe workarounds like dumping and reloading or moving tables.

ALTER

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

CREATE

Explore the CREATE statements used to define new database objects. This guide covers syntax for creating databases, tables, indexes, views, and stored routines.

DROP

Find statements to remove database objects. This section details the syntax for deleting databases, tables, users, and other entities when they are no longer needed.