Table DDL for MariaDB Xpand

This page is part of MariaDB's Documentation.

The parent of this page is: Table DDL

Topics on this page:

Overview
Compatibility
Table DDL
Executable Comments

Overview

MariaDB Xpand provides DDL (Data Definition Language) syntax to create, alter, or drop tables.

In the context of ISO 9075-2:2016, this page uses "DDL (Data Definition Language)" to refer to SQL statements in the standard's "SQL-schema statements" group.

Compatibility

MariaDB Xpand 5.3
MariaDB Xpand 6.0
MariaDB Xpand 6.1

Table DDL

ALTER TABLE with MariaDB Xpand
CREATE TABLE with MariaDB Xpand
DROP TABLE with MariaDB Xpand
Table Options with MariaDB Xpand

Executable Comments

Xpand executes comments using the format:

/*$ xpand-specific comment */

These comments are ignored by other databases. Xpand does not execute any other format of comments. These comments are often used to specify Xpand's unique table options.