Server Constraints

Understand MariaDB Server's architectural constraints. This section details limitations & design considerations, helping you optimize your database deployments for maximum efficiency and scalability.

Server Constraints Overview

Provides a high-level overview of how MariaDB Server enforces data integrity through various architectural constraint types.

AUTO_INCREMENT Constraints

Explains the limitations and behavior of AUTO_INCREMENT columns, including how they handle maximum values and gaps in sequences.

FOREIGN KEY Constraints

Details the requirements and limitations for defining foreign keys to ensure referential integrity between tables.

NOT NULL Constraints

Describes how NOT NULL constraints prevent NULL values from being stored in specific columns.

PRIMARY KEY Constraints

Outlines the rules for primary keys, which uniquely identify each record in a table and cannot contain NULL values.

UNIQUE Constraints

Explains the specific implementation and considerations for unique constraints when using MariaDB Enterprise Server.