> 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/server-usage/tables.md).

# Tables

{% columns %}
{% column %}
{% content-ref url="/pages/morhdWuOk0PNL0XMLdct" %}
[Copying Tables Between Databases and Servers](/docs/server/server-usage/tables/copying-tables-between-different-mariadb-databases-and-mariadb-servers.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
This guide explains various methods for copying tables between MariaDB databases and servers, including using `FLUSH TABLES FOR EXPORT` and `mysqldump`.
{% 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.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/Ro9nVdiya2KDRuCHYUWP" %}
[CREATE TABLE](/docs/server/server-usage/tables/create-table.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Complete guide to creating tables in MariaDB. Complete `CREATE TABLE` syntax for data types, constraints, indexes, and storage engines for production use.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/UbmyaLXHXBtJIl3r1AIx" %}
[DROP TABLE](/docs/server/server-usage/tables/drop-table.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Complete `DROP TABLE` syntax: `TEMPORARY`, `IF EXISTS`, `WAIT/NOWAIT`, `RESTRICT`/`CASCADE` options, metadata locks, atomic `DROP`, and replication behavior.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/9YRMYuBaqBXZLoIZSmtM" %}
[Data Types](/docs/server/reference/data-types.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Comprehensive MariaDB data types reference. Complete guide for numeric, string, date/time, spatial, and `JSON` types with storage specifications.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/GPSdWLvO4uRURM7G3ToJ" %}
[Storage Engines](/docs/server/server-usage/storage-engines.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Understand MariaDB Server's storage engines. Explore the features and use cases of InnoDB, Aria, MyISAM, and other engines to choose the best option for your specific data needs.
{% endcolumn %}
{% endcolumns %}

{% hint style="info" %}
The task-oriented table tutorials now live in the [Quickstart Guides](/docs/server/mariadb-quickstart-guides.md):

* [Altering Tables](/docs/server/mariadb-quickstart-guides/mariadb-alter-table-guide-1.md)
* [Getting Started with Indexes](/docs/server/mariadb-quickstart-guides/mariadb-indexes-guide.md)
* [Creating & Using Views](/docs/server/mariadb-quickstart-guides/mariadb-views-guide.md)
  {% endhint %}