# Tables

{% columns %}
{% column %}
{% content-ref url="/pages/2Qa0SqNWvkjFEXOzYufr" %}
[Altering Tables in MariaDB](/docs/server/server-usage/tables/mariadb-alter-table-guide.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Learn how to modify existing table structures using the `ALTER TABLE` statement, including adding, changing, and dropping columns and indexes.
{% endcolumn %}
{% endcolumns %}

{% 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/v8VR0FOucpYlK09Bnusy" %}
[Indexes](/docs/server/server-usage/tables/mariadb-indexes-guide-1.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Understand the different types of indexes in MariaDB, such as Primary Keys and Unique Indexes, and how to use them to optimize query performance.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/yd1T0o0mW67BBqWQjGyF" %}
[Views](/docs/server/server-usage/tables/mariadb-views-guide-1.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Discover how to create and manage views in MariaDB to simplify complex queries, restrict data access, and provide an abstraction layer over tables.
{% 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 %}


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://mariadb.com/docs/server/server-usage/tables.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.